OraFAQ Forum: Server Utilities » Import /Export from 9i to 12cR2

Home » RDBMS Server » Server Utilities » Import /Export from 9i to 12cR2 (Oracle 9i, 12c)

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

Import /Export from 9i to 12cR2 [message #637532]

Tue, 19 May 2015 12:51

krish96
Messages: 74
Registered: October 2012

Member

Hello Experts,

I have the Upgrade project and here are the details ..

source database Oracle 9i on Windows 2003 and want upgrade this to Oracle 12cR2 on Linux OS..

Please let me know if this Import/Export utility works directly on 12c or do we need to import the database into 11g first than into 12c.

Thanks in advance..

Report message to a moderator

Re: Import /Export from 9i to 12cR2 [message #637533 is a reply to message #637532]

Tue, 19 May 2015 13:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

krish96 wrote on Tue, 19 May 2015 10:51

Hello Experts,

I have the Upgrade project and here are the details ..

source database Oracle 9i on Windows 2003 and want upgrade this to Oracle 12cR2 on Linux OS..

Please let me know if this Import/Export utility works directly on 12c or do we need to import the database into 11g first than into 12c.

Thanks in advance..

exp & imp will work between V9 & V12 databases without using any intervening versions

Report message to a moderator

Re: Import /Export from 9i to 12cR2 [message #637534 is a reply to message #637532]

Tue, 19 May 2015 13:12

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Read section "Using Different Releases of Export and Import" of the documentation.

Report message to a moderator

Re: Import /Export from 9i to 12cR2 [message #637535 is a reply to message #637533]

Tue, 19 May 2015 15:17

krish96
Messages: 74
Registered: October 2012

Member

thank you, Is there any Character SET that needs to be set in 12c database while creating ..

Report message to a moderator

Re: Import /Export from 9i to 12cR2 [message #637536 is a reply to message #637535]

Tue, 19 May 2015 15:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

krish96 wrote on Tue, 19 May 2015 13:17

thank you, Is there any Character SET that needs to be set in 12c database while creating ..

The character set of the V12 database should be the same or a super-set of the V9 character set.

Report message to a moderator

Re: Import /Export from 9i to 12cR2 [message #637546 is a reply to message #637535]

Tue, 19 May 2015 23:59

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

krish96 wrote on Tue, 19 May 2015 22:17

thank you, Is there any Character SET that needs to be set in 12c database while creating ..

The same documentation page explains the character set issue.
Please read it.

Report message to a moderator

Previous Topic:	Load data using sql loader..
Next Topic:	KUP-11024: This external table can only be accessed from within a Data Pump job.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 20 09:54:03 CDT 2025