Database Software

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!

Too many Invalid objects after refreshing the schema using IMPDP

Santosh PradhanJul 4 2012 — edited Jul 5 2012

Hi All,

I am trying to refresh my UAT schema with the latest production database backup using IMPDP but after the refresh i am getting 1781 invalid objects in the database.
I have also executed UTLRP script and also tried compling the objects manully but they are not getting compiled. Following are the specifications for the same:

OS: RHEL 5.7
DB: 11.2.0.2 64 bit SE.

IMPDP command:
impdp username/passwd dumpfile=file_name logfile=logfile_name directory= datapump remap_schema=a_prod:b_uat

The default tablespaces are same for both the schemas.

What could be the problem in this?
Please reply as this is urgent

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 2 2012

Added on Jul 4 2012

#database-key-features, #export-import-sql-loader-external-tables

9 comments

2,524 views