Forum Stats

  • 3,838,560 Users
  • 2,262,382 Discussions
  • 7,900,688 Comments

Discussions

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

User_GY6ZA
User_GY6ZA Member Posts: 4 Green Ribbon
edited Aug 3, 2022 7:41AM in General Database Discussions

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?

Answers