Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: Beginner
Mar 20, 2001

DB2 Migrate to Oracle 8i?!

This tip provided by Experts Exchange

DB2 Migrate to Oracle 8i?!

 

This tip provided by Experts Exchange.

 

Question:

Hi all,
One of our client want to migrate their existing database system DB2 to Oracle 8i. I searched the IBM
and Oracle website but still couldn't find any hint. In my opinion, I will export DB2 to OS file and
import it to Oracle 8i. But I couldn't find which file format that Oracle 8i import utility supported?
Would you mind give me some suggestion!
Thanks!

 

Accepted Answer:

Eric,

The Oracle import utility is for reading dumps created with Oracle's export utility.
You may have to use a delimited file and use Oracle's Sql*Loader utility to load each table.

Dennis

 

Comment:

Hi,

There is a better way to migrate a schema and data from DB2 to Oracle

DevX Staff
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap