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).
