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/