[craiggib]

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.... :-)

[a_ranga]

I guess the best thing could be get a text file extracted from informix and load it in oracle using sqlloader.