Home » RDBMS Server » Server Utilities » Importing table from 9i to 10g (oracle database 10g)
Importing table from 9i to 10g [message #556216] Thu, 31 May 2012 23:36 Go to next message
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 ???
Re: Importing table from 9i to 10g [message #556217 is a reply to message #556216] Thu, 31 May 2012 23:47 Go to previous messageGo to next message
BlackSwan
Messages: 26766
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
Re: Importing table from 9i to 10g [message #556220 is a reply to message #556217] Fri, 01 June 2012 00:08 Go to previous message
Littlefoot
Messages: 21806
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)
Previous Topic: Migrating from 10g to 11g
Next Topic: How to backup?
Goto Forum:
  


Current Time: Thu Mar 28 14:17:25 CDT 2024