Re: Basic clarifications on DDLs

DDL statements are to create, modify the database objects like tables, indexes etc. When a DDL statement is executed, actually the data dictionary is updated with the created/updated objects info. If a create statement fails, nothing happens except that statement fails (Data dictionary is not updated)

Madhu Cherukuri <Madhu.Cherukuri_at_worldnet.att.net>

tkrishna_at_baan.com wrote in message <886489540.693698568_at_dejanews.com>...
>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 Usenet
Received on Tue Feb 03 1998 - 00:00:00 CST