Re: Informix data to Oracle

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Wed, 12 May 1999 14:53:24 -0400
Message-ID: <7hcihm$ib4$1@autumn.news.rcn.net>

Yes,

    You can edit the dbexport output to create the DDL needed to create Oracle tables. From what I recall you will have to delete the first two lines in the file and change the storage clause. I think there is one other global change you will have to make, but I can't remember what it is.

    You can then take the same files and copy and edit the copies in order to create the SQL Loader control files.

regards

Jerry Gitomer

---

Neil Truby wrote in message <7hci08$df6$1_at_taliesin.netcom.net.uk>...
>Does anyone have any experience of moving a large-ish (~10GBytes) database
>from an Informix to Oracle server?
>
>I'm wondering if there's something you can do with the output from the
>Informix dbexport utility, which produces a datbase schema and an ASCII
>unload of each table in pipe-delimited format, and Oracle's SQL *Loader.
>
>Any hints and tips would be gratefully received.
>
>Neil (ntruby_at_netcomuk.co.uk)
>
>
Received on Wed May 12 1999 - 13:53:24 CDT