Oracle Expdp issue: using where clause fails
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