Q
Problem solve Get help with specific problems with your technologies, process and projects.

Possible to migrate 600GB database to 8i in three hours?

We want to migrate database from Oracle 7.3 to 8i. The problem is that the size of the database is 600GB. They'll give only three hours time to migrate. Is it possible to migrate a database of that size to 8i in three hours? If possible, give me the path to migrate.

Since you are going from Oracle 7 to 8i, you will want to use Oracle's migration utility (MIG). Oracle even includes a Data Migration Assistant which is a GUI wizard to help you. With MIG, it doesn't matter how big your database is. A 500MB and a 500GB take nearly the same amount of time to migrate. So you will be able to fit this in to your three hour window.

Before you perform the migration may I suggest that you fully test the process on a test server. This way, you can spot your problems before your real migration. Also backup your production database before and after you migrate to the new version.

For More Information


Dig Deeper on Oracle database design and architecture

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close