OraFAQ Forum: Server Utilities » export/import from 10g/9i any other options

Home » RDBMS Server » Server Utilities » export/import from 10g/9i any other options (Oracle 10g R2 & 9i/ Solaris 10)

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

export/import from 10g/9i any other options [message #492772]

Wed, 02 February 2011 06:37

reym21
Messages: 241
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.

Report message to a moderator

Re: export/import from 10g/9i any other options [message #492773 is a reply to message #492772]

Wed, 02 February 2011 06:42

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: export/import from 10g/9i any other options [message #492819 is a reply to message #492773]

Wed, 02 February 2011 18:09

reym21
Messages: 241
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.

Report message to a moderator