Re: Informix data to Oracle

From: "Neil Truby" <ntruby@netcomuk.co.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. I remember doing something like this a couple of years ago, however, beware the discrepancies between Informix and Oracle (e.g., Oracle has no serial datatype, subtle differences in some other data types, etc.) You will not be able to migrate any stored procedures, they will have to be re-written. Apart from that, I think you will find migrating *to* Oracle fairly simple -- they do encourage this. Getting away from Oracle is a whole other ballgame. ;-) Once you've migrated, be aware that Oracle tuning and performance patterns differ almost diametrically from Informix... Hence, all the standard disclaimers about doing this for the right reasons apply. :-) HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com