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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: simple question on DDL

Re: simple question on DDL

From: <Rajesh.Rao_at_jpmchase.com>
Date: Wed, 22 Jan 2003 09:01:19 -0800
Message-ID: <F001.005378A1.20030122090119@fatcity.com>

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

Original text of this message

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