Home » RDBMS Server » Server Utilities » export/import from 10g/9i any other options (Oracle 10g R2 & 9i/ Solaris 10)
export/import from 10g/9i any other options [message #492772] Wed, 02 February 2011 06:37 Go to next message
reym21
Messages: 238
Registered: February 2010
Location: Philippines
Senior Member

Guys,

Can you suggest any other utilities that we can use to load
data from our PROD server (10g) to DEV server (9i)?
I've read some related topics here that it's not possible to
import from a HIGHER to LOWER versions of Oracle.
We've tried (many times) EXPorting selected tables from the 10g dB, then IMPort it to the 9i dB and we've haven't succeeded anyhow. PROD & DEV have a different schema/owner but the same table structures.

Thanks in advance.






Re: export/import from 10g/9i any other options [message #492773 is a reply to message #492772] Wed, 02 February 2011 06:42 Go to previous messageGo to next message
Michel Cadot
Messages: 67569
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes you can import into a lower version but you must first export with exp utility of this lower version (exp 9i in your case).
It works unless you use some specific features that are not available in 9i.

Regards
Michel

Re: export/import from 10g/9i any other options [message #492819 is a reply to message #492773] Wed, 02 February 2011 18:09 Go to previous messageGo to next message
reym21
Messages: 238
Registered: February 2010
Location: Philippines
Senior Member

Thanks for this sir...
But please elaborate more for me.

How can we get then the 10g data to be loaded to 9i?
Our Apps team need the data from the production
to simulate, then enhanced the applications' reports
generation features.

I just heard of the DATA PUMP or SQLLOAD utility of
Oracle, can we just use this instead?
Sorry for this, I'm not an experienced DBA.

Thanks again.
Re: export/import from 10g/9i any other options [message #492820 is a reply to message #492819] Wed, 02 February 2011 18:17 Go to previous messageGo to next message
BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal
Senior Member
>How can we get then the 10g data to be loaded to 9i?
use DB_LINK between the 2 databases.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_5005.htm#i2061505
Re: export/import from 10g/9i any other options [message #492821 is a reply to message #492820] Wed, 02 February 2011 18:28 Go to previous message
reym21
Messages: 238
Registered: February 2010
Location: Philippines
Senior Member

Thank you sir, for this.

Regards...
Previous Topic: Can hot backup called as logical backup
Next Topic: Multiple DB in a single sqlplus window
Goto Forum:
  


Current Time: Fri Dec 04 00:01:37 CST 2020