Home » RDBMS Server » Server Utilities » database exp/imp...!!
database exp/imp...!! [message #347495] Thu, 11 September 2008 21:32 Go to next message
dbareddy
Messages: 7
Registered: August 2008
Junior Member
Hi,
I'm using the Oracle 9i and upgrading it to 10g. And want to use EXP/IMP utility to export the database from 9i to 10g.

is it possible to export DB in 9i and import in 10g using EXP/IMP utility?
which command should i use to import in 10g, either IMP or IMPDP.

And is viceversa possible, i.e, exporting DB in 10g and importing in 9i using EXPDP/IMPDP ?

Thanks in advance.
Re: database exp/imp...!! [message #347497 is a reply to message #347495] Thu, 11 September 2008 22:00 Go to previous messageGo to next message
BlackSwan
Messages: 25038
Registered: January 2009
Location: SoCal
Senior Member
>is it possible to export DB in 9i and import in 10g using EXP/IMP utility?
yes

>which command should i use to import in 10g, either IMP or IMPDP.
IMP

>And is viceversa possible, i.e, exporting DB in 10g and importing in 9i using EXPDP/IMPDP ?
NO
Re: database exp/imp...!! [message #347521 is a reply to message #347495] Fri, 12 September 2008 00:18 Go to previous message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In addition: basically, you should perform export using the source database's EXP utility version (9i EXP in your case), and import the data using the target database's IMP utility version (10g IMP in your case).
Previous Topic: Resize of datafile
Next Topic: oracle database to another oracle test server
Goto Forum:
  


Current Time: Mon Dec 05 13:15:43 CST 2016

Total time taken to generate the page: 0.05332 seconds