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 previous 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
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Need help in Export Import
Next Topic: "ORA-00904 POLTYP: invalid identifier" when export
Goto Forum:
  


Current Time: Mon Sep 21 01:53:48 CDT 2020