Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Removing Invalid objects from dba_objects...

861979May 18 2011 — edited May 18 2011

I am getting an error during the OEM install. I did "select count(*) from dba_objects where status='INVALID'" and the count was about 4550. I then ran the script from sqlplus: @$ORACLE_HOME/sysman/admin/emdrep/sql/core/latest/admin/admin_recompile_invalid.sql sysman. After that, the count was 8. I retried the install, but still get this error.

how to remove the invalid objects?

Appreciate your help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 15 2011

Added on May 18 2011

#general-database-discussions

2 comments

7,430 views