OraFAQ Forum: Server Utilities » Data pump to transfer file from previous version of Oracle

Home » RDBMS Server » Server Utilities » Data pump to transfer file from previous version of Oracle

Wed, 12 September 2007 10:57

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?

Wed, 12 September 2007 11:00

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.

Wed, 12 September 2007 11:35

Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Datapump is for 10g and up.
Below you have to use exp/imp.

Regards
Michel

Wed, 12 September 2007 14:46

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?

Wed, 12 September 2007 15:42

Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Both.

Regards
Michel

Wed, 12 September 2007 18:53

coolboy2005in
Messages: 12
Registered: July 2007
Location: Herndon

Junior Member

Thanks Michel

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

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

Goto Forum:

]

Current Time: Sat Jun 15 04:27:51 CDT 2024