Migrating data from 9i on Unix to 10g on Linux |
 |
EXPERT RESPONSE FROM: Brian Peasland

|
 |
|


|
| > |
QUESTION POSED ON: 19 October 2005
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.
|
|
|
To continue reading for free, register below or login
To read more you must become a member of SearchOracle.com
');
// -->

If you are mixing platforms in this manner, then you have a few options at your disposal.
- 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.
- Dump the data to a text file as you have indicated, then ingest with SQL*Loader or other utility (like External Tables).
- 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.
|
|
|

|
|
 |

 |
 |
Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
|
 |
 |
 |
|
 |
 |
 |
|
 |
|
 |