Home » RDBMS Server » Server Utilities » Need to Import from 8i to 10gR2 (Windows NT)
Need to Import from 8i to 10gR2 [message #451384] Wed, 14 April 2010 05:14 Go to next message
pokhraj_d
Messages: 117
Registered: December 2007
Senior Member
Hi,
At my current organisation there are two instances are running one is at 8i and another one is 10g.
I want to migrate all the datas from 8i to 10g.
I have already taken the export from 8i with the below command:-

exp file=<<PATH>> full=y logfile=<<PATH>> compress=y

Now I want to import it to 10g DB.
Can I do the import with that below command?

imp file=<<PATH>> full=y logfile=<<PATH>> ignore=y compile=y

Regards-
Raj
Re: Need to Import from 8i to 10gR2 [message #451387 is a reply to message #451384] Wed, 14 April 2010 05:29 Go to previous messageGo to next message
Michel Cadot
Messages: 67653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes but to be sure you'll have to test it.

Regards
Michel
Re: Need to Import from 8i to 10gR2 [message #451465 is a reply to message #451384] Wed, 14 April 2010 15:17 Go to previous messageGo to next message
Littlefoot
Messages: 21648
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Basically, you should do the export using the source database EXP version (8i in your case), and import data using target database IMP version (10g in your case).
Re: Need to Import from 8i to 10gR2 [message #451492 is a reply to message #451465] Thu, 15 April 2010 02:22 Go to previous message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Littlefoot wrote on Wed, 14 April 2010 15:17
Basically, you should do the export using the source database EXP version (8i in your case), and import data using target database IMP version (10g in your case).


Good Call LittleFoot Smile
Previous Topic: import hangs
Next Topic: Export oracle error messages
Goto Forum:
  


Current Time: Mon Jan 25 00:49:28 CST 2021