expdp using more than 1 query clause in one parameter file
Hi all
Any idea how may i export using expdp using more than 1 query= clause in one shoot in one parameter file, I'm doing on this way because i do have some character setting issues for specific Chinese language settings in specific columns needs to be update it
My idea it's to concatenate different "Query=" in one single parameter file
DIRECTORY=EXP_TABLES
TABLES=YBNLOCAL02.CODE_DETL
DUMPFILE=ctcr_58912_table_ybnlocal02_58912Y.dmp
LOGFILE=ctcr_51314_table_ybnlocal02_58912Y.log
##Query=YBNLOCAL02.CODE_DETL:"WHERE CATGRY_ID = '27' and code_num_identif = 'N'" ,
Query=YBNLOCAL02.CODE_DETL:"WHERE CATGRY_ID = '27' and code_num_identif = 'Y'"