| impdp can't read the file [message #674312] |
Fri, 18 January 2019 16:13  |
 |
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 #674352 is a reply to message #674312] |
Tue, 22 January 2019 07:23  |
joy_division
Messages: 4963
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
