Re: How to import informix data into Oracle?

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/ -*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*- Received on Thu Jun 24 1999 - 01:36:41 CDT