This forum is currently locked. You can't register or post questions at this time. (read more)

impdp: object does not match

All posts relating to Oracle database administration.

Moderator: Tim...

royalyogi
Senior Member
Posts: 181
Joined: Tue Apr 23, 2013 3:59 pm

impdp: object does not match

Postby royalyogi » Thu Aug 01, 2013 2:56 pm

we have taken expdp on schema S from target database A and impdp have done on source database B.
But number of objects count is not matching on db B. when have done expdp & impdp database was idel. No DML,DDL activity has happened.

Kindly let us know resolve the gap of objects count.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: impdp: object does not match

Postby Tim... » Thu Aug 01, 2013 9:08 pm

Hi.

First, you need to check both the export and import logs to see if there were any relevant failures or warnings that might explain why there are missing objects.

Next you need to compare the two schemas to identify what the missing objects are.

Finally, it is sometimes useful to generate an SQL file from the dump file to identify exactly what the dump file contains, so see what is actually missing compared to the source database.

Unfortunately, there is no simple trick to do this. It involves you investigating the difference.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

royalyogi
Senior Member
Posts: 181
Joined: Tue Apr 23, 2013 3:59 pm

Re: impdp: object does not match

Postby royalyogi » Fri Aug 02, 2013 6:14 am

Great. I will check logs of expdp and impdp and will try identify the issue. But as you said it is not easy job to compare the missing objects. Since schema size is big..

Could you please help give link or steps to generate sql file from the dump file to identify the cuase.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: impdp: object does not match

Postby Tim... » Fri Aug 02, 2013 10:10 am

Hi.

Just add the SQLFILE parameter to the import. Instead of importing, it will now just write to the SQLFILE you specify.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 9 guests