OraFAQ Forum: Unix » Migration from oracle 8i IBM Z/OS mainframe to 10gR2 on IBM AIX

Home » Infrastructure » Unix » Migration from oracle 8i IBM Z/OS mainframe to 10gR2 on IBM AIX

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

Migration from oracle 8i IBM Z/OS mainframe to 10gR2 on IBM AIX [message #248406]

Thu, 28 June 2007 22:37

darshanmeel
Messages: 44
Registered: June 2007
Location: India

Member

Hi

WE want to migrate the database from oracle 8i(8.1.7.4) on IBMZ/OS to oracle 10g r2 on IBM AIX Unix server. Do anyone have any idea what are the methods to do so?

I have done lot of research and found that i have only two options

1. Export and import
2. CTAS

But both of these methods are not preferrable for the data size that i have.(300GB). Please let me know if there is any alternate methods to do?

or if not any then how to make the above mentioned two methods fatser?

Report message to a moderator

Re: Migration from oracle 8i IBM Z/OS mainframe to 10gR2 on IBM AIX [message #248568 is a reply to message #248406]

Fri, 29 June 2007 10:10

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

darshanmeel wrote on Thu, 28 June 2007 21:37

Yes IMPORT $ EXPORT

The size of the databse is big enough.

Do you know your indexes size?
theres and option of export only data without indexes and then create indexes later on here.

And i guess theres no other option for converting this.

Report message to a moderator

Previous Topic:	ftp Return Code
Next Topic:	RAW device

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 07:50:16 CDT 2025