This Content Component encountered an error
Q

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.

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

Dig deeper on Oracle DBA jobs, training and certification

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close