Home » RDBMS Server » Server Administration » catalog.sql & catproc.sql (oracle 10g 10.2.0.1, 32-bit)
catalog.sql & catproc.sql [message #554913] Sat, 19 May 2012 00:51 Go to next message
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
Re: catalog.sql & catproc.sql [message #554919 is a reply to message #554913] Sat, 19 May 2012 09:01 Go to previous messageGo to next message
BlackSwan
Messages: 26763
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.
Re: catalog.sql & catproc.sql [message #554928 is a reply to message #554919] Sat, 19 May 2012 11:04 Go to previous message
Michel Cadot
Messages: 67809
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
...but recompilation of all dependent objects that is all your procedures/packages...

Regards
Michel

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


Current Time: Sun Apr 11 05:31:11 CDT 2021