OraFAQ Forum: Server Utilities » Import problem in oracle 10g

Home » RDBMS Server » Server Utilities » Import problem in oracle 10g

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Import problem in oracle 10g [message #171725]

Thu, 11 May 2006 04:46

rafi_aamiri
Messages: 34
Registered: September 2005

Member

Hi,

I have a dump taken from oracle 9i in windows environment.

I was able to import in 9i successfully.

When I tried to import in oracle 10g it gives an error

imp-00002 : failed to open testdb.dmp for read

Please help me in this regard.

Report message to a moderator

Re: Import problem in oracle 10g [message #171727 is a reply to message #171725]

Thu, 11 May 2006 04:57

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Posting the same question on every forum will not fetch you the result faster. Please be patient.

And post the export and import command that you used.

Is your .dmp file is situated at the same location from where you are running your import command?

Report message to a moderator

Re: Import problem in oracle 10g [message #171737 is a reply to message #171727]

Thu, 11 May 2006 05:33

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Looks like a user error to me. Is file testdb.dmp readable? Did you specify the correct directory path to it?

Report message to a moderator

Re: Import problem in oracle 10g [message #171779 is a reply to message #171737]

Thu, 11 May 2006 07:55

Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

This is what Oracle says about it:

Quote:

IMP-00002 failed to open string for read

Cause: Import failed to open the export file for reading. This message is usually followed by a device message from the operating system.

Action: Take appropriate action to restore the device.

Report message to a moderator

Re: Import problem in oracle 10g [message #171951 is a reply to message #171727]

Fri, 12 May 2006 08:05

rafi_aamiri
Messages: 34
Registered: September 2005

Member

i never asked to be answered fast.

your response is no help to me.

give proper solution or leave it pls don't disturb the members of the forum

Report message to a moderator

Re: Import problem in oracle 10g [message #171982 is a reply to message #171951]

Fri, 12 May 2006 14:24

Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Excuse me?!?

I can only guess who you are talking to, but - as far as I can tell - YOUR response isn't helpful at all. We still don't know actual EXP and IMP commands, whether you specified correct path to the .DMP file or any other useful information.

All we know is that you have a problem. Fine. Don't disturb other forum members with this fact.

Report message to a moderator

Re: Import problem in oracle 10g [message #172022 is a reply to message #171982]

Sat, 13 May 2006 04:57

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Quote:

never asked to be answered fast.

your response is no help to me.

give proper solution or leave it pls don't disturb the members of the forum

@Littlefoot

I think the OP was pointing me.

@rafi aamiri

If you can't post the complete information then how can you expect the help from others.

Report message to a moderator

Re: Import problem in oracle 10g [message #172028 is a reply to message #172022]

Sat, 13 May 2006 07:00

Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Well, that's what I thought too (but one can never tell unless it's explicitly written). I just hope that OP didn't disturb you too much Wink

Report message to a moderator

Re: Import problem in oracle 10g [message #172119 is a reply to message #172022]

Mon, 15 May 2006 00:33

rafi_aamiri
Messages: 34
Registered: September 2005

Member

enough of your advice.....

I got the solution....... with proper people.........

Report message to a moderator

Re: Import problem in oracle 10g [message #177292 is a reply to message #172119]

Tue, 13 June 2006 21:46

alicia
Messages: 12
Registered: June 2006
Location: Malaysia

Junior Member

Hi Rafi,

I am facing the same problem with you which is IMP-00002: failed to open dmp file for read. The file is exported from Oracle 8(i), and I am using 10(g). May I know what is the solution that help you in solving problem?

Thanks & Regards,
Alicia.

Report message to a moderator

Re: Import problem in oracle 10g [message #177299 is a reply to message #177292]

Wed, 14 June 2006 01:00

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Please do not hijack other people's threads. Start your own!

Report message to a moderator

Previous Topic:	SQL*Loader convert Char to NULL
Next Topic:	IMP-00002: failed to open localdb.dmp file for read.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 00:41:13 CDT 2024