Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Posts
    6

    Unanswered: Extracting DB2 data into Oracle

    We are beginning to look at integrating data from an IBM DB2 database on a mainframe into Oracle applications. Currently, we have Oracle 8i, but will migrate to 9i within the year.

    Does anyone have any experience with extracting data directly from a DB2 database into an Oracle application? If so, what tools are you using?

    Thanks!

  2. #2
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Cool

    You can do it two ways:

    - with a tool - Data Junction

    - manually (export to flat file and use Oracle SQL*Loader)

    The first one will cost you some $$$, the second one - some time.

    Hope that helps,

    clio_usa
    OCP DBA
    visit our web site: Here
    .
    .
    .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •