Skip to Main Content
Forums

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!

INVALID Oracle Database Catalog Views 10.1.0.5.0

523938Jul 9 2008 — edited Jul 22 2008
I am trying to resolve an INVALID state on the Oracle Database Catalog Views component of an Oracle 10.1.0.5.0 database.

I was trying to resolve an issue with Data Pump by running: catalog.sql, catproc.sql and catexp.sql as SYS to add the EXFSYS schema.

Doing this made the Oracle Database Catalog Views go INVALID.

I have 61 invalid objects after running utlrp.sql, 26 of these are owned by SYS.

Anyone know of a good way to resolve this issue or a metalink note, other link they can guide me to? I would like to avoid having to rebuild the database.

Thanks!!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 19 2008
Added on Jul 9 2008
#general-database-discussions
4 comments
2,978 views