Home » RDBMS Server » Server Utilities » impdp can't read the file (Windoes 10, Oracle 12C)
impdp can't read the file [message #674312] Fri, 18 January 2019 16:13 Go to next message
juliama
Messages: 1
Registered: January 2019
Junior Member
I try to import files into tables in ETL schema (run as ETL user):
I know that I need to use impdp not imp.
c:\Data> impdp ETL/****@//******** tables=TRX.HL_ID_CONVERSION_H, TRX.DS_EXTERNAL_TRAINING_M, TRX.DS_ORDER_VOLUMES_T DIRECTORY=TEST_DUMP4 REMAP_SCHEMA=TRX:ETL REMAP_TABLESPACE="%":TESTSPACE DUMPFILE=DMPRD_%U.dmp nologfile=y
Result:
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "C:\Data/DMPRD_01.dmp" for read
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory

I don't like combination of slash and backslash in file name, but don't find the way to avoid it.
Added cluster=no statement (in case something with node permitions) with no effect.

User ETL have dba privileges.
Created directory as ETL user:
SQL > create directory TEST_DUMP4 as 'C:\Data';
grant read, write on directory TEST_DUMP4 to EXP_FULL_DATABASE;
check privileges on this directory:
SELECT * FROM all_tab_privs WHERE table_name = 'TEST_DUMP4';
GRANTOR GRANTEE TABLE_SCHEMA TABLE_NAME PRIVILEGE
SYS ETL SYS TEST_DUMP4 EXECUTE
SYS ETL SYS TEST_DUMP4 READ
SYS ETL SYS TEST_DUMP4 WRITE
ETL EXP_FULL_DATABASE SYS TEST_DUMP4 READ
ETL EXP_FULL_DATABASE SYS TEST_DUMP4 WRITE

Check that dump files exists on local computer:
c:\Data>dir
01/16/2019 01:41 PM <DIR> .
01/16/2019 01:41 PM <DIR> ..
12/20/2018 05:59 PM 66,437,120 DMPRD_01.dmp
12/20/2018 06:00 PM 1,073,741,824 DMPRD_02.dmp
Re: impdp can't read the file [message #674313 is a reply to message #674312] Fri, 18 January 2019 17:01 Go to previous messageGo to next message
BlackSwan
Messages: 26643
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Consider to use PARFILE to avoid the command line processor getting in the way.

OS directory 'C:\Data' must have OS file permission mask that allows your OS process to read & write OS data files in this directory
Re: impdp can't read the file [message #674319 is a reply to message #674312] Sat, 19 January 2019 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 66728
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The problem may be about your instance owner privileges (not your OS process ones) on the OS directory.

Re: impdp can't read the file [message #674352 is a reply to message #674312] Tue, 22 January 2019 07:23 Go to previous message
joy_division
Messages: 4947
Registered: February 2005
Location: East Coast USA
Senior Member
I don't get it.
You have a linux error about file not existing, yet you have your directory object as a windows file.
Datapump runs on database server and the directory is on that server, not local.
Previous Topic: Need help in Export Import
Next Topic: "ORA-00904 POLTYP: invalid identifier" when export
Goto Forum:
  


Current Time: Sat Dec 14 18:09:11 CST 2019