DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Hybrid View

  1. #1
    Join Date
    Jul 2003
    Orange County, CA

    oracle 9i/sybase to 9i interface

    I'm looking for suggestions on which tools/utilities could be used to design/program 2 separate interfaces. The first interface would be from a Internal 9i DB (A) to a External 9i DB (B). The 2nd interface would be from a Sybase DB to the same 9i DB (B). I'm aware that SQL Loader could be used for a static transfer of tables/tablespaces, but I've been tasked to design a dynamic/online interface to transfer the data as it's committed at approximately 5 minute intervals. The difference in the interfaces (9i to 9i versus Sybase to 9i)is that the Sybase DB to 9i DB interface will include an XML data with no/minimal constraints on the data.

    Thanks much.....

  2. #2
    Join Date
    Jul 2003
    Check out "Heterogeneous Connectivity". It allows Oracle to sort of seamlessly connect to other DBMSs.

    Oracle Hetero doc
    Tom Best

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.