Q

Migrating Oracle from NT to Windows 2003

I need to migrate Oracle 7.3, currently running on Windows NT, to Windows Server 2003 and later to Oracle9i. Is it possible to do and how?

I need to migrate Oracle 7.3, currently running on Windows NT, to Windows Server 2003 and later to Oracle9i. Is it possible to do and how?

Oracle 7.3 is not certified to run on either Windows NT or Windows Server 2003, so if you're not having problems...

with your database now, you may as soon as you migrate your operating system to Windows 2003. Have a look at the certification matrix.

What you might want to consider is migrating the Oracle 7.3 to 9i or 10g on a different server running Windows 2003. If you choose to use Oracle's export and import utilities to accomplish this, the basic steps are as follows:

  • Create new database on the Windows 2003 server
  • Export the existing Oracle 7.3 database
  • FTP the dmp file to the Windows 2003 server
  • Import into the newly created database

Migrating from Oracle 7.3 to 9i or 10g is a quite a change so you will want to test this migration thoroughly to ensure that the applications supported by the database still function as expected.

This was last published in May 2006

Dig Deeper on Oracle database export, import and migration

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close