Muhammad Nadeem Chaudhry's Blog


How to compile invalid objects?

Posted in Uncategorized by Muhammad Nadeem Chaudhry on December 1, 2011

This is a simple post to learn how to compile invalid objects. My suggestion is to do these steps daily (to keep ur self away from any expecting  Emails or phone calls)

1- Log in to unix or linux as applmgr user.

2- Find the number of invalid objects:

   SQL>sqlplus Username/Password

   SQL>Select COUNT (*) from DBA_OBJECTS where status=’INVALID’;

   You can use utlrp.sql script to compile invalid objects

   $ORACLE_HOME/rdbms/admin

   SQL>@utlrp.sql

   After that check again by using same sql statement

   SQL>select Count (*) from dba_objects where status=’INVALID’;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s


%d bloggers like this: