Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003

    Unanswered: Best practice for this replication scenario

    Hi all

    I need to replicate about 1.5 million records every night from an Informix database to my Oracle 9i database. Informix runs on AIX and Oracle on Solaris.

    I have looked at Transparent Gateways and also wondered if I shouldn't try a java procedure to connect to Informix via JDBC and then select/insert the records (not sure if I can do that)
    The data in my DB will be truncated before each replication.

    I have no access to the Informix database or box...only a view. The Oracle DB is mine.

    Any suggestions would be welcome.... :-)

  2. #2
    Join Date
    May 2002
    I guess the best thing could be get a text file extracted from informix and load it in oracle using sqlloader.

Posting Permissions

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