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

Last updated on JUNE 10, 2009

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms