Database is ABCD and Production DB Schema/User name : XYZ

I have created a DB structure with exact same tablespaces

tnsping ABCD works fine...

Created a User Name and Pwd (XYZ_User/ pwd) and granted all Admin permissions.


now trying import the XYZ.dmp file using impdp command as below:

set Oracle_SID=ABCD

impdp dumpfile=XYZ.dmp full=Y logfile=xyz.log

user: sys as sysdba
pwd : **********

Database import completed with lots of errors...All tables are present but only 2 tables are showing records...For rest of the tables num_rows is (NULL).

I am not a DBA, Hence would need detailed explanations...Any suggestions are appreciated. Thanks in Advance.