Re: simple question on DDL

Very good point, Raj. I didn't wonder just for the sake it; there was meat to it ;)

Now that this has been raised, any ideas, anybody?

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, January 22, 2003 12:01 PM

>
> That raises another doubt. For an simple insert statement, could also
> update the UET$ or FET$ tables? So, if the purpose was to preserve all
> changes to the data dictionary, What's different between OBJ$, COL$ and
> these space management tables?
>
> Thanks
> Raj
>
>
>
>
>
> "Arup Nanda"
> <arupnanda_at_ho To: Multiple recipients of
list ORACLE-L <ORACLE-L_at_fatcity.com>
> tmail.com> cc:
> Sent by: Subject: Re: simple question
on DDL
> root_at_fatcity.
> com
>
>
> January 22,
> 2003 09:58 AM
> Please
> respond to
> ORACLE-L
>
>
>
>
>
>
> My guess will be to preserve the changes to the data dictionary, which are
> just Oracle tables anyway. When you create a table, a record goes to TAB$,
> SEG$ and so on and so forth. Unless there is a commit these information is
> not visible.
>
> But now that you asked, I wnder why the same objective couldn't have been
> done through autonomous transactions.
>
> Arup
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, January 22, 2003 6:33 AM
>
>
> > Hi friends
> >
> > Why DDL statements performs auto commit ? What is the exact reason
behind
> > that one?
> > Anyone can share his/her opinions!!
> >
> > Thanks & regards
> > BanarasiBabu
> > --
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: Rajesh.Rao_at_jpmchase.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: arupnanda_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).