OraFAQ Forum: Server Administration » Way to compile invalid objects

Home » RDBMS Server » Server Administration » Way to compile invalid objects (9.2.0.8.0, 8.1.7.4.0, 10.2.0.4.0 , SunOS )

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

Way to compile invalid objects [message #541193]

Sun, 29 January 2012 09:36

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

Report message to a moderator

Re: Way to compile invalid objects [message #541194 is a reply to message #541193]

Sun, 29 January 2012 09:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

what needs to be done depends upon who owns the object & why they are not VALID.

 1  select owner, count(*) from dba_objects where status != 'VALID'
  2* group by owner order by 1
SQL> /

OWNER				 COUNT(*)
------------------------------ ----------
DBADMIN 				7
HR					4
SCOTT					1
SYS					1
USER1				       27
USER2					2

Report message to a moderator

Re: Way to compile invalid objects [message #541195 is a reply to message #541194]

Sun, 29 January 2012 10:00

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Swan,

Quote:

what needs to be done depends upon who owns the object & why they are not VALID.

I see invalid objects owned by schema 'JACK' which is the main schema (we create all
application related objects under this schema) ,PUBLIC,SYS and SYSTEM.

Now please suggest how to compile based on above answer.

Report message to a moderator