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: to
This problem can occur on any platform.


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.

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.


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

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