Forum Stats

  • 3,872,042 Users
  • 2,266,370 Discussions


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

Ajay AN
Ajay AN Member Posts: 6 Green Ribbon
edited Aug 3, 2022 7:41AM in General Database Discussions

Our database version is Oracle

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?