11gR2 Upgrade and Invalid Objects
Trying to upgrade from 10gR2 to 11gR2 using the expdp / impdp method. I've got an 11gR2 database created (with the standard schemas). I took a full database export of my 10gR2 database and moved the file over to the new server. I import the dumpfile using the impdp full=y method. And I'm getting several thousand errors. Mostly tables/objects already exists because they were created during the database creation. But when I run the utlrp.sql script i get:
OBJECTS WITH ERRORS
-------------------
0
DOC>#
ERRORS DURING RECOMPILATION
---------------------------
0
when there really is invalid objects... A bunch of invalid objects:
SQL> select count(*) from dba_objects where status!='VALID';
COUNT(*)
----------
43
My source database only had one invalid object ... So i'm not sure why these are all invalid. When I try to compile them they don't want to compile either ... So I'm not sure if something is happening during my full datatabase import or whats going on.