Home » RDBMS Server » Server Utilities » importing 9i dump into 10g (oracle 10g windows xp)
importing 9i dump into 10g [message #512756] Wed, 22 June 2011 01:22 Go to next message
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
Re: importing 9i dump into 10g [message #512757 is a reply to message #512756] Wed, 22 June 2011 01:25 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
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 Go to previous messageGo to next message
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
Re: importing 9i dump into 10g [message #512818 is a reply to message #512799] Wed, 22 June 2011 07:12 Go to previous messageGo to next message
Littlefoot
Messages: 21690
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).
Re: importing 9i dump into 10g [message #512830 is a reply to message #512818] Wed, 22 June 2011 07:52 Go to previous message
ThomasG
Messages: 3211
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 ~ $

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


Current Time: Wed Dec 01 22:48:49 CST 2021