Home » RDBMS Server » Server Utilities » IMP-00002: failed to open localdb.dmp file for read.
IMP-00002: failed to open localdb.dmp file for read. [message #177363] Wed, 14 June 2006 06:15 Go to next message
alicia
Messages: 12
Registered: June 2006
Location: Malaysia
Junior Member

Hi experts,

Actually i found a similiar problem in this forum, and the person who asked this question is already found the solution, however, the solution is not posted.

Hope you guys can help me =)

I fail to import a dmp file into my local db. The error msg is IMP-00002: failed to open localdb.dmp file for read. Import file: EXPDAT.DMP >
....

The file is exported from Oracle 8(i), and I am using 10(g). May I know what should I do now.

Please advice.

Thanks & Regards,
Alicia.
Re: IMP-00002: failed to open localdb.dmp file for read. [message #177366 is a reply to message #177363] Wed, 14 June 2006 06:28 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
What does your import command look like? Does the path to the dump file have spaces in it?
icon14.gif  Re: IMP-00002: failed to open localdb.dmp file for read. [message #177367 is a reply to message #177366] Wed, 14 June 2006 06:33 Go to previous messageGo to next message
alicia
Messages: 12
Registered: June 2006
Location: Malaysia
Junior Member

Hi ebrian,

Thanks for your posting! I have requested moderator to close this thread as I found that I made the careless mistake myself.

The command as below:

imp intra_owner_local/owner123@INTRANETLOCAL FILE=billingLocal.dmp fromuser=intra_owner touser=intra_owner_local;

I have solved the problem.

Sorry for any inconvenience.

Thanks!

Cheers,
Alicia

[Updated on: Wed, 14 June 2006 06:33]

Report message to a moderator

Re: IMP-00002: failed to open localdb.dmp file for read. [message #177370 is a reply to message #177363] Wed, 14 June 2006 06:36 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Request from OP

Hi moderator, Please close this tread as i found that is myself doing the careless mistake. I have done it. Sorry for any inconvenience. Thanks & Regards, Alicia
Closed.

MHE
Previous Topic: Import problem in oracle 10g
Next Topic: Impor error columns xmltype and clob
Goto Forum:
  


Current Time: Mon Jul 01 00:39:02 CDT 2024