OraFAQ Forum: Server Administration » catalog.sql & catproc.sql

Home » RDBMS Server » Server Administration » catalog.sql & catproc.sql (oracle 10g 10.2.0.1, 32-bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

catalog.sql & catproc.sql [message #554913]

Sat, 19 May 2012 00:51

ishika_20
Messages: 339
Registered: December 2006
Location: delhi

Senior Member

Hi All,

I just want to know.
If bi-mistake i run catalog & catproc.sql on my production DB instead of testDB, what are the changes occurred on my ProdDB? My all system views will get refreshed, my database will not re-start.

Waiting for our kind response.

Regards
Ishika

Report message to a moderator

Re: catalog.sql & catproc.sql [message #554919 is a reply to message #554913]

Sat, 19 May 2012 09:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

running catalog or catproc (again) should not have any impact on the database.

Report message to a moderator

Re: catalog.sql & catproc.sql [message #554928 is a reply to message #554919]

Sat, 19 May 2012 11:04

Michel Cadot
Messages: 68786
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

...but recompilation of all dependent objects that is all your procedures/packages...

Regards
Michel

Report message to a moderator

Previous Topic:	EXTENT MANAGEMENT LOCAL AUTOALLOCATE
Next Topic:	Oracle RMAN backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Oct 08 18:32:22 CDT 2026