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" <[EMAIL PROTECTED]> 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@ho To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > tmail.com> cc: > Sent by: Subject: Re: simple question on DDL > root@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" <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
