Moving existing 10g database to a new server and to 11g R2 database
Hi gurus,
I am a newbie. My situation is like this:
I have a existing oracle database 10.2.0.2 on Red Hat Enterprise Linux (32) OS. I got to move this to a new server and into a 11g R2 database. The size of the Database is around 700Gig.
My plan is :
1)Create a 11g R2 database with the same name on a new Red Hat Enterprise Linux machine.
2)Export whole Database from existing 10g Database using Data pump.
3)Importing the dump file into the new 11g R2 database by adjusting corresponding tablespaces.
Questions:
1)would this work at all.
2)What all could I consider to move the dump file from source to target over a network to do it in less down time.
I am a newbie. My situation is like this:
I have a existing oracle database 10.2.0.2 on Red Hat Enterprise Linux (32) OS. I got to move this to a new server and into a 11g R2 database. The size of the Database is around 700Gig.
My plan is :
1)Create a 11g R2 database with the same name on a new Red Hat Enterprise Linux machine.
2)Export whole Database from existing 10g Database using Data pump.
3)Importing the dump file into the new 11g R2 database by adjusting corresponding tablespaces.
Questions:
1)would this work at all.
2)What all could I consider to move the dump file from source to target over a network to do it in less down time.
0