Database Administration (MOSC)

MOSC Banner

DBMS_DATAPUMP.ADD_FILE ORA-39001: invalid argument value

edited Feb 17, 2016 6:32AM in Database Administration (MOSC) 2 commentsAnswered ✓

Hello,

I have  Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 and scrip to create user and run schema import

I run below code:

handle :=  DBMS_DATAPUMP.OPEN('IMPORT','SCHEMA', NULL, 'QA_PW_ORACDC4');

DBMS_OUTPUT.PUT_LINE('handle for Restoring initial QA_PW_ORACDC4 database= ' || handle);

  DBMS_OUTPUT.PUT_LINE('aa');

DBMS_DATAPUMP.ADD_FILE(handle,'MODEL_FLX95SP3.DMP','DATA_PUMP_DIR',NULL,DBMS_DATAPUMP.KU$_FILE_TYPE_DUMP_FILE);

and i get below error when DBMS_DATAPUMP.ADD_FILE is running:

ORA-39001: invalid argument value

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79

ORA-06512: at "SYS.DBMS_DATAPUMP", line 2953

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