Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Basic clarifications on DDLs

Basic clarifications on DDLs

From: <tkrishna_at_baan.com>
Date: 1998/02/03
Message-ID: <886489540.693698568@dejanews.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US