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. Since the databases are 70GB in size I would also need to estimate the import time.

    Requires Free Membership to View

    Login

    By submitting your registration information to SearchOracle.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchOracle.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

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.

This was first published in April 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top