Q

Migrating data from 9i on Unix to 10g on Linux

What about migrating data from Oracle 9i on Unix to 10g on Linux? We had to extract data into a flat file using WisdomForce FastReader and then load it back with input for SQL*Loader that FastReader created. What other choices did we have?

What about migrating data from Oracle 9i on Unix to 10g on Linux? Will your advice work in the same way then? We had a 400 GB database and doing this didn't work for us. We had to extract data into a flat file using WisdomForce FastReader and then load it back with input for SQL*Loader that FastReader created. What other choices did we have? By the way FastReader was able to extract 400 GB in less then an hour.
If you are mixing platforms in this manner, then you have a few options at your disposal.

  1. Use Oracle's export/import utilities to dump the data and ingest into the new database. This works well since you can also copy indexes, stored procedures, triggers, views, etc.
  2. Dump the data to a text file as you have indicated, then ingest with SQL*Loader or other utility (like External Tables).
  3. Create a database link from one system to another, then pull (or push) the data across the link with INSERT SELECT statements or the SQL*Plus COPY command.

In the last two options, you will have to generate the DDL (using the DBMS_METADATA pkg) to create the non-table objects in the new database.

This was first published in October 2005

Dig deeper on Oracle database backup and recovery

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close