Database Administration (MOSC)

MOSC Banner

DBMS_DATAPUMP.ADD_FILE ORA-39001: invalid argument value

edited Feb 17, 2016 4:35AM in Database Administration (MOSC) 11 commentsAnswered ✓

Hello,

I know i duplicated that discussion..

On Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit i try use DBMS_DATAPUMP package to add dump file::

declare

  handle number;

begin

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

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

end;

/

when i run that code then following errors is occurring:

ERROR at line 1:

ORA-39001: invalid argument value

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

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

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

ORA-06512: at line 5

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