14 June 2010
3 DB Migration from Oracle 8.0.5 to Oracle 10g
I have a DB of 10G size in Oracle 8.0.5 We need to migrate this (structure will remain as is) to Oracle 10g.
What is the easiest method to do this, will export taken in Oracle 8.0.5 work with import of Oracle 10g. Is there any other easy way?
What is the easiest method to do this, will export taken in Oracle 8.0.5 work with import of Oracle 10g. Is there any other easy way?
There are verious ways to migrate data from Oracle 8.0.5 to Oracle 10.2.*. Details are mentioned below,
Using Export/ Import:
1. Export Full Oralce 8.0.5 database using 8.0.5 EXP utility.
2. Take a cold backup of 8.0.5 database.
3. Apply Oracle 10g related operating system patches to server.
4. Install Oracle 10g Software.
5. Create Oracle 10g instance.
6. Create DATA and INDEX tablespaces with same name as Oracle 8.0.5 database.
7. Import Full database in new Oralce 10g instance using 10.2.* IMP utility.
8. Recompile all invalid objects.
Using File System:
1. Take a cold backup of 8.0.5 database
2. Apply Oracle 10g related operating system patches to server.
3. Install Oracle 10g Software.
4. Create Oracle 10g instance.
5. Detach file system of Oracle 8.0.5 database and attach it to new Oracle 10g database.
6. Run database upgrade scripts manually on the new 10g database.
7. Recompile all inavalid objects.
You can also use Oracle Database Upgrade Assistance tool. This is a GUI based tool provided by oracle for upgrading database to higher version.
Subscribe to:
Post Comments (Atom)
3 comments:
As per compatibility matrix, there is no direct upgrade path from Oracle 8.0.5 to 10.2.
Even export and import (export using Oracle 8.0.5 and import using Oracle 10g) is not supported as per compatibility matrix. Connections are not possible between 8.0.5 and 10.2
You can try with a test schema level export (not full database export) using Oracle 8.0.5 and import using Oracle 10.2. For details, http://download.oracle.com/docs/cd/B19306_01/server.102/b14238/preup.htm ,see Table 2-1 Upgrade Paths.
Always use lower version export utility for schema level export and use higher version import utility for import.
@ Oracle 10g
The compatibility matrix which you provided is a general guide for interoperability of Oracle client. It also mentions that the compatibility is product specific.
Oh great. Awesome post.Thanks for sharing.
Please give your valuable comments.