Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Basic clarifications on DDLs
Hi ,
Please help me in understanding the DDLs better :
(1) Are Rollback Segments allocated to DDLs ? If not then how to
explain the following situation :
" DDLs as I understand are just DMLs on the dictionary tables. Hence a CREATE TABLE statement would basically insert & update many rows into the DD tables. Suppose a create table statement aborts in the middle , what is the status of the DMLs done on the DD tables , how is consistency maintained ? "
(2) Why are DDLs treated as ATOMIC transactions ? In other words , why
do the DDLs ( treated as a single transaction ) get automatically
commited ?
Thanks in advance.
PLEASE EMAIL YOUR RESPONSE TO tkrishna_at_baan.com
Krish.
-------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to UsenetReceived on Tue Feb 03 1998 - 00:00:00 CST
![]() |
![]() |