COM> Organization: Apple Computer, Inc. Subject: Informix <-> Oracle export/import of tables?
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_at_oracle select * from calldetail_at_informix where calldetail_at_oracle is the local database table on the Oracle V7 RDBMS (A/UX based machine currently) and the calldetail_at_informix is the remote table. I understand that I will at least need to have INFORMIX-NET drivers loaded on the machine where Oracle resides. What I am still r
