impdp error - bad dump file specification [message #655722] |
Fri, 09 September 2016 16:24 |
|
jturck
Messages: 7 Registered: September 2016
|
Junior Member |
|
|
I'm ery new to oracle's expdp/impdp.
I received a dump file from the oracle DBA (exp_CNTRJTURCK.dmp) he created using expdp and I'm trying to load it to a new Oracle RDS instance. I used a perl script to load the dump file to the DATA_PUMP_DIR and I'm now attempting to import/build my new schema and load the data.
The command I'm running is:
impdp oracleadmin@ORCL schemas=CNTRJTURCK directory=DATA_PUMP_DIR dumpfile=exp_CNTRJTURCK.dmp logfile=exp_CNTRJTURCK.log
And the message I received is:
Import: Release 11.2.0.1.0 - Production on Fri Sep 9 21:16:07 2016
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31619: invalid dump file "/rdsdbdata/datapump/exp_CNTRJTURCK.dmp"
ORA-27072: File I/O error
Linux-x86_64 Error: 22: Invalid argument
Additional information: 4
Additional information: 1
Additional information: -1
I believe the dump file was loaded to the DATA_PUMP_DIR because I can see this:
SQL> select DIRECTORY_NAME, DIRECTORY_PATH from dba_directories;
DIRECTORY_NAME
------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
BDUMP
/rdsdbdata/log/trace
DATA_PUMP_DIR
/rdsdbdata/datapump
ADUMP
/rdsdbdata/log/audit
SQL> SELECT * from table(RDSADMIN.RDS_FILE_UTIL.LISTDIR('DATA_PUMP_DIR'));
FILENAME
--------------------------------------------------------------------------------
TYPE FILESIZE MTIME
---------- ---------- ---------
datapump/
directory 4096 09-SEP-16
import.log
file 460 07-SEP-16
exp_CNTRJTURCK.log
file 468 07-SEP-16
FILENAME
--------------------------------------------------------------------------------
TYPE FILESIZE MTIME
---------- ---------- ---------
exp_CNTRJTURCK.dmp
file 1575583744 09-SEP-16
Ideas?
|
|
|