Way to compile invalid objects [message #541193] |
Sun, 29 January 2012 09:36 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/7587f1e1dc7836c6b81ad21d234a2aad?s=64&d=mm&r=g) |
Jack14
Messages: 497 Registered: December 2011 Location: INDIA
|
Senior Member |
|
|
Hi,
I see lot of invalid objects in my databases especially owned by user PUBLIC,SYS and SYSTEM.
In this case what should my approach?I mean how to compile invalid objects.
I am confuse as to which way to compile invalid objects from the list below.
1.rerun catalog.sql and catproc.sql
2.Login as sysdba and run the script run utlrp.sql script from $ORACLE_HOME/rdbms/admin
SQL>@?/rdbms/admin/utlrp.sql
3.Login as sysdba and run the script
exec dbms_utility.compile_schema('XXXXX')
4.Compile invalid objects individually.
alter package pkname compile
Please suggest me the right way to compile invalid objects.
Thank you
|
|
|
|
|
|
|
|