Home » RDBMS Server » Server Utilities » Data pump to transfer file from previous version of Oracle
Data pump to transfer file from previous version of Oracle [message #267162] Wed, 12 September 2007 10:57 Go to next message
coolboy2005in
Messages: 12
Registered: July 2007
Location: Herndon
Junior Member
Hi Everyone,

I had a doubt weather we can use data pump to transfer data from 8i or 9i database into 10g?

Will exp or imp utilities be of any help?
Re: Data pump to transfer file from previous version of Oracle [message #267163 is a reply to message #267162] Wed, 12 September 2007 11:00 Go to previous messageGo to next message
coolboy2005in
Messages: 12
Registered: July 2007
Location: Herndon
Junior Member
Well it's a general question so I had not written my OS environment.

If still required I am using RHEL4.
Re: Data pump to transfer file from previous version of Oracle [message #267175 is a reply to message #267162] Wed, 12 September 2007 11:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Datapump is for 10g and up.
Below you have to use exp/imp.

Regards
Michel
Re: Data pump to transfer file from previous version of Oracle [message #267231 is a reply to message #267175] Wed, 12 September 2007 14:46 Go to previous messageGo to next message
coolboy2005in
Messages: 12
Registered: July 2007
Location: Herndon
Junior Member
So can I use exp/imp for getting data from 8i to 9i or from 9i to 10g?
Re: Data pump to transfer file from previous version of Oracle [message #267238 is a reply to message #267231] Wed, 12 September 2007 15:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Both.

Regards
Michel
Re: Data pump to transfer file from previous version of Oracle [message #267255 is a reply to message #267162] Wed, 12 September 2007 18:53 Go to previous message
coolboy2005in
Messages: 12
Registered: July 2007
Location: Herndon
Junior Member
Thanks Michel

[Updated on: Wed, 12 September 2007 18:54]

Report message to a moderator

Previous Topic: Importing a schema
Next Topic: Is it possible to export a view
Goto Forum:
  


Current Time: Wed Dec 25 09:38:14 CST 2024