ORA-39166: Object was not found or could not be exported or imported with ORA-31655: no data or metadata objects selected for job | parfile ( parameter file )

Hi,

Sometimes You can get ” ORA-39166: Object was not found or could not be exported or imported with ORA-31655: no data or metadata objects selected for job ” error.

 

Details of error are as follows.

[msdbadm01]/home/oracle $ expdp MehmetSalih/Deveci@MSDBA directory=PUMP tables=MehmetSalih."ItemValues" dumpfile=ItemValues%U.dmp parallel=8 cluster=n logfile=ItemValues.log compression=all flashback_scn=16657639598137

Export: Release 12.2.0.1.0 - Production on Tue Jun 2 10:28:44 2020

Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

Starting "MehmetSalih"."SYS_EXPORT_TABLE_01": MehmetSalih/********@MSDBA directory=PUMP tables=MehmetSalih.ItemValues dumpfile=ItemValues%U.dmp parallel=8 cluster=n logfile=ItemValues.log compression=all flashback_scn=16657639598137
ORA-39166: Object MehmetSalih.ITEMVALUES was not found or could not be exported or imported.
ORA-31655: no data or metadata objects selected for job
Job "MehmetSalih"."SYS_EXPORT_TABLE_01" completed with 2 error(s) at Tue Jun 2 10:29:57 2020 elapsed 0 00:01:10

 

 

This database is case sensitive, so table name is ItemValues correctly, not ITEMVALUES.

 

I have tried like below.

[msdbadm02]/home/oracle $ expdp MehmetSalih/Deveci@MSDBA directory=PUMP tables=MehmetSalih./"ItemValues/" dumpfile=ItemValues%U.dmp parallel=8 cluster=n logfile=ItemValues.log compression=all flashback_scn=16657639598137

Export: Release 12.2.0.1.0 - Production on Tue Jun 2 15:54:24 2020

Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Starting "MehmetSalih"."SYS_EXPORT_TABLE_01": MehmetSalih/********@MSDBA directory=PUMP tables=MehmetSalih./ItemValues/ dumpfile=ItemValues%U.dmp parallel=8 cluster=n logfile=ItemValues.log compression=all flashback_scn=16657639598137
ORA-39166: Object MehmetSalih./ITEMVALUES/ was not found or could not be exported or imported.
ORA-31655: no data or metadata objects selected for job
Job "MehmetSalih"."SYS_EXPORT_TABLE_01" completed with 2 error(s) at Tue Jun 2 15:54:54 2020 elapsed 0 00:00:20

[msdbadm02]/home/oracle $

 

But it is not run, I have tried lots of variation, but it is not change.

 

To solve this problem, I have used the parfile ( parameter file ) and it run correctly as follows.

[msdbadm02]/home/oracle $ vi expdp.par

directory=PUMP
tables=MehmetSalih."ItemValues"
dumpfile=ItemValues%U.dmp
parallel=8
cluster=n
logfile=ItemValues.log
compression=all
flashback_scn=16657639598137

 

and run it as follows.

 

[msdbadm02]/home/oracle $ expdp MehmetSalih/Deveci@MSDBA parfile=expdp.par

 

If table name is case sensitive, then use the parfile to solve this error.

 

Do you want to learn more details about Datapump ( Export – Import ) then read the following post.

https://ittutorial.org/oracle-data-pump-export-import-4/