Tuesday, December 10, 2013

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

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

Was getting the above error while trying to export using expdp (not my cup of coffee with this beast).
Basically, I was trying to export selected tables from a schema using INCLUDE=TABLE:"IN (select query

Problem was I removed SCHEMAS param in the parameter and thus it was throwing this error.

Correct Syntax (Unix):
SCHEMAS=schema_name_here
INCLUDE=TABLE:"IN (select table_name from other_schema.final_export_tabs where schema_name = 'schema_name_here' and notes is null)"

I am still trying to find a way to pass schema name along with the table so that I can try getting one export dump with multiple schemas and selected tables only... if some can find it please reply to me with the solution. Thanks in advance :)

Never mind, I figured that out.
Here is the syntax:
SCHEMAS=schema_name1,schema_name2,schema_name3
INCLUDE=TABLE:"IN (select table_name from other_schema.final_export_tabs where notes is null)"

I was worried that it might fail as there are tables which have same name in multiple schemas but no issues as expdp got them from both schemas without any issues.

No comments:

Post a Comment