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

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete

Number of Visitors