Q
Manage Learn to apply best practices and optimize your operations.

Cross-platform upgrade to 10g

I need to upgrade 9i databases on Windows NT to 10g on Linux. Since this is a cross-platform upgrade I cannot use the DBUA. Is there a standard procedure for this move? I have also read about the transport tablespace option, but I'm not sure if it will work for me as the tablespaces need to be re-created as small, meduim and large against the standard ones that exist in 9i.

I need to upgrade 9i databases on Windows NT to 10g on Linux. Since this is a cross-platform upgrade I cannot use the DBUA. Is there a standard procedure for this move? I have also read about the transport tablespace option, but I'm not sure if it will work for me as the tablespaces need to be re-created as small, meduim and large against the standard ones that exist in 9i. Since the databases are 70GB in size I would also need to estimate the import time.

Because you are migrating to a newer release (10g) on a different platform (Linux), one option is to export your data from the 9i database and import it into the newly created 10g database. Another option is to use the "create table as select" option via a database link from the 9i database to the newly created 10g database, but this will be quite slow and not as reliable as an export/import. Assuming that the Linux server is not yet a production server, you should be able to estimate the time of the import by testing it ahead of time. Use an export file from the 9i database, create your new 10g database and import the entire database or only necessary schemas. Because this database is not in use, yet, you can then drop the application schemas and test the import multiple times. If this is a production server, you should still be able to test your import; however, you should be aware that this may impact the performance of other databases or applications on that server.

Transportable tablespaces would have been an option had you been able to upgrade your 9i database to 10g first on the NT platform. You would have then been able to use transportable tablespaces to migrate your database to the Linux server. This is not an option because Oracle 10g is not certified to run on the Windows NT platform so you cannot upgrade your database in place.

Dig Deeper on Oracle database export, import and migration

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

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