Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Ignorant rollback question

Re: Ignorant rollback question

From: Eugen Nyffeler <eugen.nyffeler_at_ubs.com>
Date: Wed, 13 May 1998 19:44:13 +0200
Message-ID: <3559DBED.19EBF45E@ubs.com>


Van Messner wrote:
>
> In a database with an existing table T and index I, if you
> drop I
> drop T
> create T as
> select x from y
> create I
> And if there are no explicit commits, Then what, if any, changes are made to
> rollback segments?
>
> TIA
The drop and create are ddl-statements and they make an implicit commit! Received on Wed May 13 1998 - 12:44:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US