Home » RDBMS Server » Server Utilities » migrate table from 10g xe to oracle 9i (linux to windows)
migrate table from 10g xe to oracle 9i [message #533686] Thu, 01 December 2011 02:27 Go to next message
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.

Re: migrate table from 10g xe to oracle 9i [message #533687 is a reply to message #533686] Thu, 01 December 2011 02:29 Go to previous messageGo to next message
Michel Cadot
Messages: 66800
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous message
Littlefoot
Messages: 21530
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.
Previous Topic: Export data ordered and organized!
Next Topic: Question on export/import
Goto Forum:
  


Current Time: Sat Jan 25 13:43:43 CST 2020