Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DDL/DML and rollback
In article <1107792794.096291.252080_at_l41g2000cwc.googlegroups.com>,
yong321_at_yahoo.com says...
>
>> So, it is fairly safe to say that most all DDL (alter session being
>> an exception for exmaple) generates some undo somewhere (for the
>> dictionary changes being
>
>Wouldn't it be better to say *all* DDLs generate dictionary undo and
>alter session (as well as alter system) is *not* a DDL? Oracle
>documentation defines DDLs as those that "create, alter, maintain, and
>drop schema objects..."
>
>Yong Huang
>
fair enough ;)
concepts guides seems to term that as "session control" statement - different from ddl and dml
-- Thomas Kyte Oracle Public Sector http://asktom.oracle.com/ opinions are my own and may not reflect those of Oracle CorporationReceived on Mon Feb 07 2005 - 10:19:56 CST