import dump

Posted by Roshan on Dec 13, 2016; 8:47am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/import-dump-tp1732.html

Hello,

I have done an import using

IMPORT

export ORACLE_HOME=/u01/ora12c/product/12.1.0
export ORACLE_SID=lcms1
export PATH=$ORACLE_HOME/bin:$PATH
impdp LCMS_PROD   dumpfile=LCMS121220162042.dmp logfile=lcmsprod.expdp`(date +"%d%m%Y%H%M")`.log content=metadata_only  directory=lcms_dir


However I cannot find any objects when connecting to this user.

Extract from log file


Master table "LCMS_PROD"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
ORA-39154: Objects from foreign schemas have been removed from import
ORA-31655: no data or metadata objects selected for job
Starting "LCMS_PROD"."SYS_IMPORT_FULL_01":  LCMS_PROD/******** dumpfile=LCMS121220162042.dmp logfile=lcmsprod.expdp131220161027.log content=metadata_only directory=lcms_dir
Job "LCMS_PROD"."SYS_IMPORT_FULL_01" successfully completed at Tue Dec 13 10:27:58 2016 elapsed 0 00:00:01


Regards,
Roshan