This discussion is archived
3 Replies Latest reply: Jan 25, 2013 2:25 PM by rp0428 RSS

metadata filter using parfile

972227 Newbie
Currently Being Moderated
Hi, my parfile is as follows
DUMPFILE=1965x_metadata_exp.dmp
LOGFILE=1965x_metadata_exp.log
DIRECTORY=exports
CONTENT=METADATA_ONLY
INCLUDE=TABLE:"LIKE '%PROFIT%'"
when I run the expdp utility as
expdp "' / as sysdba'" parfile=1965x1.par 
i am getting the following error
Starting "SYS"."SYS_EXPORT_SCHEMA_02":  "/******** AS SYSDBA" parfile=1965x1.par
ORA-39168: Object path TABLE was not found.
ORA-31655: no data or metadata objects selected for job
Job "SYS"."SYS_EXPORT_SCHEMA_02" completed with 2 error(s) at 15:59:25
my question is why am i getting the error ORA-39168
because when i log into my database and execute the query "Select table_name from dba_tables where table_name like '%PROFIT%' "
I am getting two rows, so shouldn't the metadata on those two rows be exported.

Is there something wrong with the way i wrote the parfile or am I executing the expdp with parfile worng?
my database version is 11.2.0.3.0 running on AIX

THANKS

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points