Thanks. Also I have noticed while running UPGRADE CATALOG, lot of archive files are got generated. Thanks and Regards, dhan -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bradd Piontek Sent: Thursday, September 25, 2008 10:49 PM To: Shanmugam, Dhandapani; oracle-l@xxxxxxxxxxxxx Subject: Re: DDL Statements while issuing UPGRADE CATALOG Check out recover.bsq in $ORACLE_HOME/rdbms/admin. On 9/25/08, Shanmugam, Dhandapani <dhandapani.shanmugam@xxxxxxx> wrote: > > Hi Gurus, > > While we issue UPGRADE CATALOG command to update the catalog schema, > it internally sends various SQL DDL statements to the recovery catalog. > What are the sql DDL statements that run internally in RMAN. Thanks > > Thanks and Regards, > Dhan > > -- > //www.freelists.org/webpage/oracle-l > > > -- Sent from my mobile device Bradd Piontek Oracle Blog: http://piontekdd.blogspot.com Linked In: http://www.linkedin.com/in/piontekdd -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l