Database Administration (MOSC)

MOSC Banner

expdp with query fails with ORA-00904

edited Dec 2, 2015 12:54PM in Database Administration (MOSC) 6 commentsAnswered ✓

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'

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