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