Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Ignorant rollback question
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
![]() |
![]() |