Database Utilities (MOSC)

MOSC Banner

exp failing with query clause

edited Apr 3, 2018 2:25PM in Database Utilities (MOSC) 4 commentsAnswered

Source Database version : 10.2.0.3

Target database version : 9208

need to export tables with a clause condition in 10.2.0.3 and import them into 9208 database

userid="/ as sysdba"

directory=TEST

dumpfile=expdp_SR_296628_%U.dmp

logfile=expdp_SR_296628_log.log

tables=XBRADMIN.POS_HDR_TAB,XBRADMIN.POS_SKU_TAB,XBRADMIN.POS_LDS_TAB

query=\"where transdate between \'01-FEB-18\' and \'23-MAR-18\'\"

version=9.2

parallel=3

expdp fails with below error

ORA-39001: invalid argument value

ORA-39035: Data filter SUBQUERY has already been specified.

If I try to use exp utility with a modifed parfile it still fails as below

userid="/ as sysdba"

file=expdp_SR_296628_%U.dmp

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