RE: DDL Statements while issuing UPGRADE CATALOG

From: Shanmugam, Dhandapani <dhandapani.shanmugam_at_eds.com>
Date: Fri, 26 Sep 2008 00:03:13 +0530
Message-ID: <AC455BF47A745941B9FB331A4366263803526A8D@inpnm231.apac.corp.eds.com>

 

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bradd Piontek Sent: Thursday, September 25, 2008 10:49 PM To: Shanmugam, Dhandapani; oracle-l_at_freelists.org 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_at_eds.com> 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
>
> --
> http://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
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 25 2008 - 13:33:13 CDT

Original text of this message