Re: Migrating from Informix to Oracle

Madhury wrote: > Hi, > > If anyone worked on migrating from Informix database to Oracle > database, request you to please give some inputs on this regarding the > procedure to be followed and the problems faced during migration. > > TIA. I have consulted on a number of Informix to Oracle, and Oracle to Informix projects and would be glad to help ... but you can't just ask open ended questions and expect anything useful. First ... purchase a copy of Tom Kyte's book "Expert one-on-one Oracle" and carefully read the first three chapters. Next bookmark http://tahiti.oracle.com ... it is the best single source there is. Of course you can also bookmark http://www.psoug.org and click on Morgan's Library for a lot of concept demos But the most important single thing to remember is that except at a superficial level the architecture of Informix and Oracle are very different and you will not be successful in Oracle with a simple migration. Got specific questions I'll be happy to address them but it would probably be better, and more on-topic, to do so at comp.databases.oracle.server. HTH -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)