I'm attempting to do an export dump based on a query clause. The table holds 2.37bil rows and i need to dump a subset of those. Here is my parfile
DIRECTORY=EXPSOURCE
DUMPFILE=obs_fact_%u.dmp
PARALLEL=4
TABLES=schema1.observation_fact
QUERY='schema1.observation_fact:"WHERE concept_cd < ''ICD10CM:N93.0'';"'
This is producing the following error
ORA-31693: Table data object "SCHEMA1"."OBSERVATION_FACT" failed to load/unload and is being skipped due to error:
ORA-00933: SQL command not properly ended
I tired wrapping the concept_cd code in quotations rather than double ' but receiving the same error. I've been researching for awhile now with no advancement.
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
QUERY
clause is wrong because:WHERE
clause with a semi-colonwhich means that something like this should work:
Here's an example based on Scott's schema: parameter file (which looks similar to yours; I can't use the
PARALLEL
option as I'm on 11gXE):Execution: