expdp with query fails with ORA-00904
Hello
I am running the following export com againts 11.2.0.4 database
expdp /@vod10 parfile=expdp_ols_admin_vol.par
here is my parfile
TABLES= OLS_ADMIN.BILLED_TRANSACTIONS
QUERY=OLS_ADMIN.BILLED_TRANSACTIONS:"where OLS_ADMIN.STATEMENT_SUMMARY.CUSTOMER_NUMBER = CUSTOMER_NUMBER"
directory=EXPDP
logfile=2015DEC01TEST.elog
dumpfile=2015DEC01TEST%U.dmp
parallel=8
REUSE_DUMPFILES=Y
here is the error
ORA-31693: Table data object "OLS_ADMIN"."BILLED_TRANSACTIONS" failed to load/unload and is being skipped due to error:
ORA-00904: "OLS_ADMIN"."STATEMENT_SUMMARY"."CUSTOMER_NUMBER": invalid identifier
The column does exist in the table
1* select owner, table_name, column_name from dba_tab_columns where table_name = 'STATEMENT_SUMMARY' and owner = 'OLS_ADMIN' and column_name = 'CUSTOMER_NUMBER'