import dump

[Roshan]

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

[ErmanArslansOracleBlog]

Do you see the following?

ORA-39154: Objects from foreign schemas have been removed from import 

13 Ara 2016 12:01 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

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

[ErmanArslansOracleBlog]

Your problem seems to be caused by the following:
"the role IMP_FULL_DATABASE is not granted to the user who attempted to import tables into different schemas"

Check this MOS document:
Errors ORA-31655 ORA-39154 On DataPump Import (Doc ID 1341446.1)

[Roshan]

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

[ErmanArslansOracleBlog]

Roshan,

I don't see any index creation errors in your import log file.

Are you doing a full export-import? ( I only see LCSM_PROD schema objects in your import log file). So the missing indexes may be owned by other schemas which are not exported or imported? You are importing the the objects from LCSM_UAT schema to LCSM_PROD, so maybe those indexes belong to different schemas?
(In other words, Are you sure that those indexes are exported in the first place?)
What are the indexes that are missing in the target? Make a comparison on dba_indexes between source and target to find those 10 missing indexes? (what are their owner, what are their names, what is their creation time in the source on an so on..)

[Roshan]

Hello,

thanks for reply. I did a schema export of lcms_uat to lcms_prod only(without data).

[Roshan]

I will check with the user and let you know about the missing indexes. But they belong to the user lcms_uat

[ErmanArslansOracleBlog]

Answer all my questions not only the names of missing indexes.. (Their creation time and so on...)