My Oracle Support Banner

Expdp Fails with ORA-39001 And ORA-31658 (Doc ID 780465.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4
This problem can occur on any platform.

Symptoms

Expdp with a query clause could fail with the following error message if the query parameter is not specified correctly.

ORA-39001: invalid argument value
ORA-31658: specifying a schema name requires a table name

In the parfile below, when you choose to use alias in query option the expdp will fail with the above error.

DIRECTORY=EXP_DMP
DUMPFILE=alias.dmp
LOGFILE=alias.log
JOB_NAME=exp_alias
CONTENT=ALL
TABLES=sb.mediaformats,sb.mediabooklocation
QUERY=mediaformats: "where id in ( select ml.mediaid from mediabooklocation ml where rownum < 4)"

However if the alias in the query line is not mentioned then the expdp works fine.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
  Symptoms
  Cause
  Solution
  References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.