impdp: object does not match

All posts relating to Oracle database administration.

Moderator: Tim...

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.
royalyogi
Senior Member
 
Posts: 165
Joined: Tue Apr 23, 2013 3:59 pm

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
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

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.
royalyogi
Senior Member
 
Posts: 165
Joined: Tue Apr 23, 2013 3:59 pm

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
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 9 guests