Home » RDBMS Server » Server Utilities » Import /Export from 9i to 12cR2 (Oracle 9i, 12c)
Import /Export from 9i to 12cR2 [message #637532] Tue, 19 May 2015 12:51 Go to next message
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..


Re: Import /Export from 9i to 12cR2 [message #637533 is a reply to message #637532] Tue, 19 May 2015 13:02 Go to previous messageGo to next message
BlackSwan
Messages: 26545
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
Re: Import /Export from 9i to 12cR2 [message #637534 is a reply to message #637532] Tue, 19 May 2015 13:12 Go to previous messageGo to next message
Michel Cadot
Messages: 66449
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: Import /Export from 9i to 12cR2 [message #637535 is a reply to message #637533] Tue, 19 May 2015 15:17 Go to previous messageGo to next message
krish96
Messages: 74
Registered: October 2012
Member
thank you, Is there any Character SET that needs to be set in 12c database while creating ..
Re: Import /Export from 9i to 12cR2 [message #637536 is a reply to message #637535] Tue, 19 May 2015 15:25 Go to previous messageGo to next message
BlackSwan
Messages: 26545
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.
Re: Import /Export from 9i to 12cR2 [message #637546 is a reply to message #637535] Tue, 19 May 2015 23:59 Go to previous message
Michel Cadot
Messages: 66449
Registered: March 2007
Location: Nanterre, France, http://...
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.

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:
  


Current Time: Wed Jun 26 02:58:42 CDT 2019