Home » Other » General » Help!!! Convert 9i.dmp file to a 10g dmp file (Windows XP (oracle 9i & 10g))
Help!!! Convert 9i.dmp file to a 10g dmp file [message #399669] Thu, 23 April 2009 07:24 Go to next message
gmanuk101
Messages: 2
Registered: April 2009
Location: UK, SCotland
Junior Member
Help please I am at a loss.

Ive been give the task of trying to determine how to convert an oracle 9i.dmp into an oracle 10g.dmp file.

Can anyone help?

Thanks heaps

Graeme n00by Smile
Re: Help!!! Convert 9i.dmp file to a 10g dmp file [message #399671 is a reply to message #399669] Thu, 23 April 2009 07:35 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
I don't believe you can.
What you should be able to do is import the contents of the 9i dump into a 10g database using the 9i imp executable.
Re: Help!!! Convert 9i.dmp file to a 10g dmp file [message #399672 is a reply to message #399671] Thu, 23 April 2009 07:46 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You can also import the 9i dumpfile using the 10g imp executable. They are compatible in that direction.

Re: Help!!! Convert 9i.dmp file to a 10g dmp file [message #399675 is a reply to message #399671] Thu, 23 April 2009 07:52 Go to previous messageGo to next message
gmanuk101
Messages: 2
Registered: April 2009
Location: UK, SCotland
Junior Member
thanks guys...I know I can import a 9i into a 10g.

Ok so if ive imported the 9i.dmp into the 10g and perform an export from the 10g, will the file now be a 10g file or will it keep the 9i format?

Ive got to come up with an automatic way of converting 9i dmp files to 10g dmp files. and therefore 10g to any future versions our client's may take up.

any ideas? is the above import of 9i to 10g then export viable?

thanks again.

G
Re: Help!!! Convert 9i.dmp file to a 10g dmp file [message #399684 is a reply to message #399669] Thu, 23 April 2009 08:20 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
The format of the file is determined by the version of exp you use. You can use 9i exp against a 10g db - in which case you get a 9i dump file, and obviously if you use the 10g exp you'll get a 10g dump file.
Re: Help!!! Convert 9i.dmp file to a 10g dmp file [message #399685 is a reply to message #399675] Thu, 23 April 2009 08:21 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Why do you think you need to convert a 9i .dmp file to 10g?

If would say just lie and say you did it. There is no difference. 10g can read a 9i or 10g .dmp file. Now, if you want to convert it to 10g so that 9i cannot read it, then that's another story.
Previous Topic: getting data from excel into vb6 app
Next Topic: Define Oracle Architecture
Goto Forum:
  


Current Time: Fri Mar 29 00:25:26 CDT 2024