Re: import dump

Posted by Roshan on Dec 14, 2016; 5:14am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/import-dump-tp1732p1742.html

Thank you Erman. I did the above and the import completed. However, I saw that the number of indexes on the instance I have copied is different to the source.

import.PNG

I gave all privileges to lcms_prod user and reimported, still not all indexes were created.

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

lcmsprod.log
Regards,
Roshan