| 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?
|
|
|
|
| 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 | 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?
|
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
