Re: DDL/DML and rollback

On Sun, 06 Feb 2005 08:38:53 +0100, vertigo <ax178_at_wp.pl> wrote:

>Hello
>Does all DML commands generates rollback informations ?

yes

>Does all DDL command do not generate rollback informations ?

no
>
>When i use DROP TABLE command is anything saved in undo segment ?

in the system undo segment
>If yes, what for ?

Think of it: when your database crashes during drop table, and the DDL hasn't been yet automatically committed, shouldn't Oracle be capable to rollback the operation?

>
>Thanx
>Michal
>(Oracle 9.2i)

--
Sybrand Bakker, Senior Oracle DBA