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
If you reply to this email, your message will be added to the discussion below:http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/ import-dump-tp1732.html To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML
| Free forum by Nabble |