If I understand your situation correctly, you are planning to migrate an Oracle 9i database on Solaris 9 to Oracle 10g on Windows 2003. You have not given me any information about the size of the database, nor do I know anything about whether you can take an extended outage to perform the migration. If the Oracle 9i database (or application schemas within the database) is within a manageable size, I would look at using Oracle's export and import utilities. I have not used Toad's export utility so I'm not sure what it does or how complete it is. I would suggest using Oracle's utilities, instead.
The basic steps of this migration would involve taking either a full database export (or schema exports) of the Oracle 9i database, transferring the dump files (in binary mode) to the Windows 2003 server, and importing the contents into the newly created 10g database.
The Oracle Database 10g Release 2 (10.2) Upgrade Guide is an excellent starting point for reviewing your options on how to migrate your database.
For more information on using Oracle's export and import utilities, the Oracle Database 10g Release 2 (10.2) Utilities guide will provide you with good information on these utilities.
Dig Deeper on Oracle database export, import and migration
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk." Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.