Wednesday, 29 April 2015

ORA-39168: Object path TABLE was not found. ORA-31655: no data or metadata objects selected for job

With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_04":  system/******** parfile=myfile.par
Estimate in progress using BLOCKS method...
Total estimation using BLOCKS method: 0 KB
ORA-39165: Schema JBL19JAN was not found.
ORA-39168: Object path TABLE was not found.
ORA-31655: no data or metadata objects selected for job
Job "SYSTEM"."SYS_EXPORT_SCHEMA_04" completed with 3 error(s) at 10:47:25


myfile.par contents:
directory=DUMPS
dumpfile=jbl19jan.dmp
logfile=jbl19jan.log
SCHEMAS=jbl19jan
INCLUDE=TABLE:"in(SELECT t FROM jbl19jan.tlist)"


Solution:
Check if the table names in tlist table in Capital letter

No comments:

Post a Comment

Number of Visitors