Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Collaboration Suite Archived Forums
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Sep 11, 2009 2:25 PM by
Data migration (export / impor) from Oracle 8 (8.0.5 ) to Oracle 10g 10.2.0
Jan 16, 2009 11:37 AM
We have Oracle 8 (8.0.5) database on HP TRUE UNIX on top of this BAAN-IV ERP is running. Present database size 120 GB.
Now we are migrating the database to Oracle 10g R2 RAC using ASM.
Servers: HP RX 6600
Server o/s: HP-UX 11.23 (without service guard)
Storage:HP Storage Works HSV 300 (8 x 146GB)
Oracle: Oracle 10g R2
RAC is implement using ASM
We have implemented RAC setup and cluster database smoothly, it is working smoothly.
When we are importing data in to RAC database from old oracle database (Oracle 8.0.5) export dump, the database size becomes very large (250GB).
We are using ASM and OMF. all tablespaces are locally managed and uniform size is autoallocated.
Please help me regarding this.
This content has been marked as final.
Show 1 reply
Re: Data migration (export / impor) from Oracle 8 (8.0.5 ) to Oracle 10g 10.2.0
Sep 11, 2009 2:25 PM
in response to
Check your temp and undo tablespaces.If both tablespaces are big then you can recreate those tablespaces and then see the size of DB.