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 first published in May 2006

Dig deeper on Oracle database export, import and migration

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close