Q
Problem solve Get help with specific problems with your technologies, process and projects.

Migrate Oracle 9i data on Sun to 10g on Windows

I need to migrate only data from a Sun machine with Oracle 9i to Oracle 10g on a Windows 2003 Server environment.

I need to migrate only data from a Sun machine with Oracle 9i to Oracle 10g on a Windows 2003 Server environment. In the Windows environment we have two databases; one is 9i and the other one is a newly created 10g database. How can I perform this task? I used Toad to export tables and others like indexes, constraints, triggers and so on.

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

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.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close