Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: simple question on DDL
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
> 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).Received on Wed Jan 22 2003 - 11:01:19 CST
![]() |
![]() |