Ask the Expert

Transferring data from Oracle to DB2

I can transfer data from DB2 to Oracle by first unloading to a flat file and then loading it to Oracle using the SQL*LOAD utility. Is there a similar way to transfer data from Oracle to DB2? We cannot use the EXPORT utility of Oracle because the file created by EXPORT utility can only be read by the IMPORT utility of Oracle.

    Requires Free Membership to View

You could use heterogeneous services so that a non-Oracle system (DB2) appears as a single, local, Oracle database; the local Oracle server hides the distribution and heterogeneity of the data. The Oracle server accesses the non-Oracle system using Oracle8i Heterogeneous Services and a system-specific transparent gateway. Therefore, if you include a DB2 database in an Oracle distributed system, you need to obtain a DB2-specific transparent gateway so that the Oracle databases in the system can communicate with it.

The transparent gateway agent facilitates communication between Oracle and non-Oracle databases and uses the Heterogeneous Services component in the Oracle server. The agent executes SQL, procedural, and transactional requests at the non-Oracle system on behalf of the Oracle server.

See the following Oracle docs for detailed information (all docs can be found at http://technet.oracle.com):

  • Oracle8i Concepts
  • Oracle8i Distributed Database Systems
  • Oracle Open Gateway Installation and User's Guide

For More Information


This was first published in December 2002

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: