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
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
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:


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
Messages: 21811
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 May 23 07:32:38 CDT 2024