Could someone let me know how to use INCLUDE parameter to include multiple LIKE commands?.
I created the PARFILE like below and am receiving the error below. If I use only one include with LIKE is working fine.
DIRECTORY=TEST_DIR
DUMPFILE=test.dmp
LOGFILE=test.log
SCHEMAS=TEST
INCLUDE=TABLE:"LIKE ('TEST_%')"
INCLUDE=TABLE:"LIKE ('EXP_%')"
$expdp 'userid="/ as sysdba"' PARFILE=test.par
Export: Release 10.2.0.4.0 - 64bit Production on Wednesday, 06 July, 2011 16:34:17
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."SYS_EXPORT_SCHEMA_03": userid="/******** AS SYSDBA" PARFILE=test.par
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
ORA-39165: Schema TEST was not found.
ORA-39168: Object path TABLE was not found.
ORA-31655: no data or metadata objects selected for job
Job "SYS"."SYS_EXPORT_SCHEMA_03" completed with 3 error(s) at 16:34:33