Re: DDL statements and transactions

However, the DDL commands are logged by default. You can use the redo log info to undo such DDL operations.

Pramod

Ban Spam <ban-spam_at_operamail.com> wrote in message news:<Xns9282A95B62079SunnySD_at_68.6.19.6>...
> vk02720_at_my-deja.com (vk02720) wrote in
> news:4d814faa.0209071120.769db626_at_posting.google.com:
>
> > Are DDL statements like create table and delete or truncate part of
> > the transaction ?
> > I mean if you DELETE a table can you recover using ROLLBACK ?
> >
> > TIA
>
> One does NOT "DELETE a table".
> The correct command is
> DROP TABLE FUBAR;
>
> FWIW - All DDL statements issue an implicit COMMIT.
> Therefore ROLLBACK is NOT possible with any DDL statement.
>
>
>
> HTH & YMMV
>
>
>
> HAND!
Received on Tue Sep 10 2002 - 06:06:46 CEST