OraFAQ Forum: Server Utilities » Need to Import from 8i to 10gR2

Home » RDBMS Server » Server Utilities » Need to Import from 8i to 10gR2 (Windows NT)

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

Need to Import from 8i to 10gR2 [message #451384]

Wed, 14 April 2010 05:14

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

Report message to a moderator

Re: Need to Import from 8i to 10gR2 [message #451387 is a reply to message #451384]

Wed, 14 April 2010 05:29

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

Senior Member
Account Moderator

Yes but to be sure you'll have to test it.

Regards
Michel

Report message to a moderator

Re: Need to Import from 8i to 10gR2 [message #451465 is a reply to message #451384]

Wed, 14 April 2010 15:17

Littlefoot
Messages: 21823
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).

Report message to a moderator

Re: Need to Import from 8i to 10gR2 [message #451492 is a reply to message #451465]

Thu, 15 April 2010 02:22

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

Report message to a moderator

Previous Topic:	import hangs
Next Topic:	Export oracle error messages

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 13:51:11 CST 2024