Re: Informix <-> Oracle export/import of tables?

Alex Sirota (adapple@apple.com) wrote: : Hello folks. : I am cross posting this to both the Informix and Oracle newsgroups and : listservs to get the largest possible audience for my inquiry. : I am currently designing a system that needs to extract data from an : existing Informix database running on a Motorola UNIX machine. It is : Informix 4.00 SE, and it does have INET 4.0 drivers installed. We have : this machine networked on TCP/IP. : What I would like to do is fairly trivial in theory and I believe must : have been done before by many. I would like to somehow access these tables : on the Informix database FROM the Oracle database. : My goal really is to be able to do this type of SQL: : insert into calldetail@oracle : select * from calldetail@informix I've never tried this, but it's possible for u to build routines in Informix ESQLC to extract information from your tables, build routines in Oracle ProC to write this information to Oracle tables. Other middleware technology are available although I don't know if they work with your particular Informix machine. Using InfoPump for example, you can access information from Informix and "pump" it to Oracle. Today, this is an expensive solution 'cos InfoPump only works on X86 based machines running OS/2. In December, Trinzic will release a version on Unix, (I don't know if it's AIX) but u could check with Trinzic on this. Hope this helps. Mail me for more stuff...