OraFAQ Forum: Server Utilities » importing 9i dump into 10g

Home » RDBMS Server » Server Utilities » importing 9i dump into 10g (oracle 10g windows xp)

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

importing 9i dump into 10g [message #512756]

Wed, 22 June 2011 01:22

mrdb
Messages: 62
Registered: December 2009
Location: dubai

Member

how can i import the oracle 9i dump file into 10g database, while iporting i get following error imp-00002 fail to open dump file

Report message to a moderator

Re: importing 9i dump into 10g [message #512757 is a reply to message #512756]

Wed, 22 June 2011 01:25

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Explaining the error message will never help us any better.
Post the session. Verbatim.
Post the file/filesystem information.

[Updated on: Wed, 22 June 2011 01:26]

Report message to a moderator

Re: importing 9i dump into 10g [message #512799 is a reply to message #512757]

Wed, 22 June 2011 06:32

mrdb
Messages: 62
Registered: December 2009
Location: dubai

Member

backup took from oracle 9i database in windows environment. Want to import the dump file in to oracle 10g windows environment

Report message to a moderator

Re: importing 9i dump into 10g [message #512818 is a reply to message #512799]

Wed, 22 June 2011 07:12

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

Senior Member
Account Moderator

By saying "backup", you actually meant to say "export", right? Which EXP utility did you use? 9i or 10g? (should be 9i - the "source" & "lower" version). Which IMP utility did you use to import data? 9i or 10g? (should be 10g - "target" database version).

Report message to a moderator

Re: importing 9i dump into 10g [message #512830 is a reply to message #512818]

Wed, 22 June 2011 07:52

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Your syntax is most likely wrong. Or you don't have OS permissions to read the dump file.

oracle ~ $ oerr imp 00002
00002, 00000, "failed to open %s 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.
oracle ~ $

Report message to a moderator

Previous Topic:	Data Pump expdp to ASM daily
Next Topic:	Token longer than max allowable length of 258 chars

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 02:35:06 CST 2025