Home » RDBMS Server » Server Utilities » IMP Datapump error
IMP Datapump error [message #613089] Tue, 29 April 2014 12:25 Go to next message
Messages: 1
Registered: August 2007
Location: canada
Junior Member
Replace the dumpfile option with the network_link = devdb.us.oracle.com
for below errors

The command fails displaying the following error:
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/home/oracle/schema/schemas.dat" for read
ORA-27037: unable to obtain file status
What would you do to overcome the error?

[SPLIT from a 5 years old topic by LF]

[Updated on: Wed, 30 April 2014 00:09] by Moderator

Report message to a moderator

Re: IMP Datapump error [message #613090 is a reply to message #613089] Tue, 29 April 2014 12:37 Go to previous message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

On server side:
ls -l /home/oracle/schema/schemas.dat

ALWAYS, copy and paste what you do and get.
ALWAYS post your Oracle version.
Please read How to use [code] tags and make your code easier to read.

Previous Topic: SQLLDR conventional load via multiple sqlldr instances
Next Topic: importing data only in existing tables.
Goto Forum:

Current Time: Sat May 18 06:19:18 CDT 2024