RE: Import Informix

There are several ways:
1) Oracle has a gateway product which makes an Informix database to look

   like oracle database to another oracle gateway. It used to be called    Informix gateway.
2) You can write a set of perl programs (using DBI, of course) that will

   copy the data from the Informix database to an Oracle database. This is    ideal for a one time deal.
3) you can write an external procedure for Oracle8i which would access Informix

   database and get you the required data. 4) You can use Java/JDBC to accomplish the same thing. 5) You can export your informix data into a set of ASCII files and load them into

   Oracle with SQL*Loader (lightning fast, but messes up my weekends)

I'm sure that there are other ways, too, but that's all I can think of on Friday afternoon.

-----Original Message-----
From: isabel.alcantarilla_at_es.jazztel.com [mailto:isabel.alcantarilla_at_es.jazztel.com] Sent: Friday, June 16, 2000 12:10 PM
To: Multiple recipients of list ORACLE-L Subject: Import Informix

Hi,
Is it possible to import a Informix database into Oracle database? or Is it possible to do anything to get the informix tables with the data in Oracle database?

This question is very important and I need an urgent answer.

Thank you

Chabe

-- 
Author: 
  INET: isabel.alcantarilla_at_es.jazztel.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).