Re: Informix 2 Oracle databases transfert
> From: etienne@venus.univ-lr.fr (Etienne Gourdon)
> Subject: Informix 2 Oracle databases transfert
> Date: 24 Mar 1995 11:49:00 GMT
> Reply-To: etienne@venus.univ-lr.fr (Etienne Gourdon)
> Organization: Universite de La Rochelle
>
> We're using both Oracle V7 and Informix databases.
>
> We want to transfert Informix databases to Oracle.
>
> Do you know any procedure concerning this transfert ?
>
> In fact, we just want to create ORACLE dbimport files
> from INFORMIX dbexport files.
>
> I guest it's really possible in PERL on some tools like this.
>
> Thanks...
>
> ---------------------------------------------------------------
> etienne@cri.univ-lr.fr
> (NeXT/MIME-mail are welcome !)
> ---------------------------------------------------------------
I had to do the same transfer. The technique I used was to write
an Informix-4GL report which wrote an entire SQL*Loader script.
A few tips for this method: top, bottom, and left margins are all
zero; page length is 1; right margin is whatever is needed for your
longest line. I used an "INFILE *" SQL*Loader command and put both
control statements and data into the same file.
If you don't have I4GL, I suppose you could use DBaccess to generate
your data, and then hand edit the SQL*Loader control statements,
either at the beginning of your data file or in a separate file
and use the "INFILE filename" command.
Bon chance,
Alan
+---------------------------+-----------------------------------------------+
| R. Alan Popiel | Internet: alan@den.mmc.com |
| Martin Marietta, SLS | Voice: 303-977-9998 |
| P.O. Box 179, M/S 3810 | Standard disclaimers apply. Cutesy ones, too. |
| Denver, CO 80201-0179 USA | Your mileage may vary. Void where prohibited. |
+---------------------------+-----------------------------------------------+