OraFAQ Forum: Server Utilities » migrate table from 10g xe to oracle 9i

Home » RDBMS Server » Server Utilities » migrate table from 10g xe to oracle 9i (linux to windows)

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

migrate table from 10g xe to oracle 9i [message #533686]

Thu, 01 December 2011 02:27

orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA

Member

Hi,
can anybody suggest how to migrate a table from 10g xe database to a oracle9i database.Both the database are stand alone and we cannot create a dblink.

Report message to a moderator

Re: migrate table from 10g xe to oracle 9i [message #533687 is a reply to message #533686]

Thu, 01 December 2011 02:29

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Export (9i) followed by import in new database in the only way.

Regards
Michel

[Updated on: Thu, 01 December 2011 02:29]

Report message to a moderator

Re: migrate table from 10g xe to oracle 9i [message #533691 is a reply to message #533687]

Thu, 01 December 2011 02:34

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

Senior Member
Account Moderator

Just in case you didn't understand what Michel said: you should use EXP utility that belongs to 9i version and export data from your 10gXE database. Then you'd import that data into 9i database using IMP utility that belongs to 9i.

Generally speaking, export data using lower database version's EXP version (9i vs. 10g -> use 9i EXP), import data using target database version's IMP utility (target is 9i - use 9i IMP).

Shortly: both EXP and IMP should be 9i.

Report message to a moderator

Previous Topic:	Export data ordered and organized!
Next Topic:	Question on export/import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 07:16:17 CST 2024