Database Utilities (MOSC)

MOSC Banner

Oracle Expdp issue: using where clause fails

edited Sep 5, 2017 4:39PM in Database Utilities (MOSC) 5 commentsAnswered ✓

hi, Oracle 12.1.0.2.PSU July 2017, failing on single table export with a where clause - this is on a Linux OUL6 server:

expdp  /

DUMPFILE=PF92PROD_EXPDP_SYSADM_PS_PV_ATT_DB_SRV.DMP

LOGFILE=PF92PROD_EXPDP_SYSADM_PS_PV_ATT_DB_SRV.LOG

TABLES="SYSADM.PS_PV_ATT_DB_SRV"

DIRECTORY=DATA_PUMP_DIR

CONTENT=ALL

METRICS=Y

QUERY=SYSADM.PS_PV_ATT_DB_SRV:"WHERE TO_CHAR( TRUNC( LASTUPDDTTM ), 'RRRR' ) = '2009'"              <**** this is the issue

Error:

LRM-00116: syntax error at ')' following 'LASTUPDDTTM'

I cannot seem to get this right! help

thanks, Steve

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