Database Utilities (MOSC)

MOSC Banner

expdp using more than 1 query clause in one parameter file

edited Jun 26, 2018 5:23PM in Database Utilities (MOSC) 3 commentsAnswered

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'"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center