OraFAQ Forum: Server Utilities » Importing table from 9i to 10g

Home » RDBMS Server » Server Utilities » Importing table from 9i to 10g (oracle database 10g)

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

Importing table from 9i to 10g [message #556216]

Thu, 31 May 2012 23:36

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

Hi Friends,

I want to import my oracle 9i dump file into oracle 10g version. What should i do ???

Report message to a moderator

Re: Importing table from 9i to 10g [message #556217 is a reply to message #556216]

Thu, 31 May 2012 23:47

BlackSwan
Messages: 26759
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

use the "imp" utility

Report message to a moderator

Re: Importing table from 9i to 10g [message #556220 is a reply to message #556217]

Fri, 01 June 2012 00:08

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

Senior Member
Account Moderator

According to OraFAQ Wiki, Compatibility Matrix for Export And Import Between Different Oracle Versions is described in My Oracle Support note ID 132904.1.

Generally speaking:
- export data using the EXP utility of the lowest database version involved (9i in your case)
- import data using the IMP utility of the target database (10g in your case)

Report message to a moderator

Previous Topic:	Migrating from 10g to 11g
Next Topic:	How to backup?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 02 10:39:45 CST 2021