Database Utilities (MOSC)

MOSC Banner

ORA-39001: invalid argument value when using a variable to assign the value for dbms_datapump.metada

edited Oct 15, 2018 10:38AM in Database Utilities (MOSC) 7 commentsAnswered
Hi

I've been trying to get datapump working to an acceptable speed for use by our testing team.  After spending a couple of weeks using the expdp and impdp command line tools, I found that using the DBMS_DATAPUMP API gave far better performance.  I am now trying to incorporate this into an existing package in order to roll out the functionality to our users.  However, when trying to run the sub program in the package I get the following error:

ORA-39001: invalid argument value

I found that this relates to the following part of the code:

                               dbms_datapump.metadata_filter(   

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center