Ask the Expert

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?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

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: