Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, oracle.

Asked: April 19, 2017 - 12:58 pm UTC

Last updated: April 20, 2017 - 8:19 am UTC

Version: 12.1.0

Viewed 1000+ times

You Asked

Hi team,

I have imported the database schema from one db to another db with same schemas details and it is completed successfully but when i comparing the objects it is showing difference
So, can you pls let me know in impdp some specific object which will not be import.

Where import                    Original DB objects       Difference
---------------------------------------------------------------------
PACKAGE BODY 2  PACKAGE BODY 2  0
PACKAGE         2  PACKAGE         2  0
QUEUE         4  QUEUE         4  0
TYPE         5  TYPE         5  0
MATERIALIZED VIEW 9 MATERIALIZED VIEW 8 -1       --> 1 is not imported
TRIGGER        10  TRIGGER         9  -1       --> 1 is not imported
DATABASE LINK  11  DATABASE LINK 11  0
LOB        16  LOB         21  5        --> 5 are not imported
SEQUENCE       21  SEQUENCE 21  0
JOB        21  JOB         22  1        --> 1 is not imported
FUNCTION       27  FUNCTION 29  2        --> 2 are not imported 
VIEW        42  VIEW         42  0        
INDEX        66  INDEX         83  17   --> 17 are not imported
PROCEDURE     170  PROCEDURE 171  1         --> 1 is not imported  
TABLE       348  TABLE         352  4         --> 4 are not imported
       TABLE PARTITION 23  23        --> 23 are not imported



Thanks

and Connor said...

Typically these errors can cascade, eg, if a table does not get imported, then its indexes are not, and any materialised views that need that table do not etc etc...

So often the issue is actually quite small.

But we need to see the *full* import log to examine further.


Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Data Pump

All of the database utilities including Data Pump are explained in the Utilities guide.