I was seeing the ORA errors when trying to export tables using the include filter.  I wanted to use INCLUDE=table:”LIKE ‘SAL%'”.  As highlighted in the support document “Doc ID 2020410.1, there are some limitations.  I attempted lower case, upper case and separating my parameter file values into different lines but the error persisted.

[alinafetest-database.us-west-2.net:oracle:alinafetest:$DATA_DUMP]: expdp ${XX_DBWORK_XX} parfile=table_before_drop.par………
FLASHBACK automatically enabled to preserve database integrity.
Starting “DBWORK”.”SYS_EXPORT_SCHEMA_06″: dbwork/******** parfile=table_before_drop.par
Estimate in progress using BLOCKS method…
Total estimation using BLOCKS method: 0 KB
ORA-39165: Schema TESTSCHEMA was not found.
ORA-39168: Object path TABLE was not found.
ORA-31655: no data or metadata objects selected for job
Job “DBWORK”.”SYS_EXPORT_SCHEMA_06″ completed with 3 error(s) at Mon May 8 15:17:10 2017 elapsed 0 00:02:19

I read the last error first, “no data or metadata..” so I look at the parameter file, and everything looks okay.  I had run this before when I wanted to exclude some tables – that worked.  The “Object path Table” error seems to indicate something is malformed in my syntax, originally I had escaped the quotation marks, being Linux and all, but in the parameter file, this works without escaping.

Editing the file and using their recommended syntax works.

include=TABLE:”IN (select table_name from all_tables where owner=’TESTSCHEMA’ and (table_name like ‘SOME_PREP%’ or table_name like ‘ALL_PREP%’ or table_name like ‘THAT_GROUP%’ or table_name like ‘THOSE_USERS%’))”

It works:

 [alinafetest-database.us-west-2.net:oracle:alinafetest:$DATA_DUMP]: vi table_before_drop.par
[alinafetest-database.us-west-2.net:oracle:alinafetest:$DATA_DUMP]: expdp ${XX_DBWORK_XX} parfile=table_before_drop.par
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting “DBWORK”.”SYS_EXPORT_SCHEMA_06″: dbwork/******** parfile=table_before_drop.par
Estimate in progress using BLOCKS method…
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 39.62 MB
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported “TESTSCHEMA”.”SOME_TABLE_11461″ 907.4 KB 9442 rows

 

Advertisements