How to import informix data into Oracle?

Hi all, I'm trying to experiment how to import the Informix export files (.unl with dbexport) to Oracle tables..... Is it possible? Thanks in advance for any idea.... H.V

Of course. 1. Use the export.sql file to create your schema. modify it as needed to convert the informix syntax to oracle. I did not have to change much. 2. create a load_database shell script. with entries like: sqlload / CONTROL=entity.ctl LOG=./logs/entity.log BAD=./logs/entity.bad DATA=./data/entit00104.unl; 3. create a ctl file for each table like 'entity.ctl': LOAD DATA INTO TABLE entity REPLACE FIELDS TERMINATED BY '|' ( entity_id integer EXTERNAL, entity char) 4. run the load script For more information go to http://technet.oracle.com/ and register. Then search for informix and download and read the conversion kit stuff. Cheers, Joe Edwards On Thu, 24 Jun 1999, Huy Vu wrote: > Hi all, > > I'm trying to experiment how to import the Informix export files (.unl with > dbexport) to Oracle tables..... > > Is it possible? > > Thanks in advance for any idea.... > > H.V -*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*- The keeper of the Wastewater Engineering Virtual Library (WWEVL) the WWEVL URL == http://www.cleanh2o.com/ -*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-