Oracle database Import ORA-39001: invalid argument value ORA-39000: bad dump file specification

hello,

I was trying to import dump file to my test oracle database using the following import line:

Import: Release 11.2.0.4.0 - Production on Wed jan 10 10:52:34 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31640: unable to open dump file "C:\app\admin/admin/orcluat/dpdump/expfULLDB.DMP" for read

ORA-27041: unable to open file

OSD-04002: unable to open file

Solutions :

    1. Check oracle directory .
SELECT * FROM DBA_DIRECTORIES

or, You can see all the privileges for all directories with the following script :

select *from
   all_tab_privs
where
   table_name in
  (select
      directory_name
   from
      dba_directories);

Directory privileges:  READ and WRITE.

{ermanTestDB:oracle}/export/>ls -la
total 8
drwxrwxrwx    3 oracle   dba             256 Jan 05 12:59 .
drwxr-xr-x   32 root     system         4096 Jan 09 19:26 ..
drwxrwxrwx    2 oracle   dba             256 Jan 05 12:59 ExpImp
{ermanTestDB:oracle}/export/>

{ermanTestDB:oracle}/export/>chmod -R 777 .
{ermanTestDB:oracle}/export/>chmod -R 777 ..
{ermanTestDB:oracle}/export/>ls -la
total 8
drwxrwxrwx    3 oracle   dba             256 Jan 05 12:59 .
drwxrwxrwx  32 root     system         4096 Jan 09 19:26 ..
drwxrwxrwx    2 oracle   dba             256 Jan 05 12:59 ExpImp
{ermanTestDB:oracle}/export/>


 

Problem is solved. Have a good day.

Hits: 15

Leave a Reply

Your email address will not be published. Required fields are marked *