Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

We are trying to import data using a query parameter in expdp, but it fails with errors

Ajay ANAug 3 2022 — edited Aug 3 2022

Our database version is Oracle 11.2.0.4.0.

Query parameter in the EXPDP statement we are using is,
query=<schema_name>.<old_table_name>:\"where DATE >= '01-JUL-20'\"

Below are the errors,
ORA-31693: Table data object <object_name> failed to load/unload and is being skipped due to error:
ORA-00904: "JUL": invalid identifier

Can somebody help us with this and let us know what's wrong with above statement?

Added on Aug 3 2022

#11g, #dba, #general-database-discussions

3 comments

319 views