Migrating 60GB database
Triveni asked how long it takes to migrate a 60GB Informix database to Oracle. Neil Truby and another poster answered jokingly, and Daniel Morgan said too little information was given. Traveller2003 listed what would be needed: table counts and sizes, disks, same machine or not, Quick I/O, hardware, datatype conversion, stored procedures and fragmentation. No actual estimate was given.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi, How much time does it take to migrate 60GB of data from Informix database to Oracle database. Regards, Triveni
"Triveni" <btnaidu@yahoo.com> wrote in message news:ee43e368.0409052225.516eec4d@posting.google.com... > Hi, > How much time does it take to migrate 60GB of data from Informix > database to Oracle database. 2 days 15 hours 17 minutes and 8 seconds.
Triveni wrote: > Hi, > How much time does it take to migrate 60GB of data from Informix > database to Oracle database. The rest of your life, cobber... -- Strewth! Stick a sock in it, Sheila!
Triveni wrote: > Hi, > How much time does it take to migrate 60GB of data from Informix > database to Oracle database. > > > Regards, > Triveni If your question is serious ... you have provided far to little information for anyone to give you a useful answer. For all we know you have one table, one record, and a 60GB AVI file. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)
You need to provide more Information like :- How many tables and Sizes of tables ? What type of disk ? Is the migration on the same machine ? Moving to Oracle are you using Veritas Quick I/O if not you will get performance issues on normal file systems ? What machine , OS and memory ? etc etc. Other things you need to consider :- Will Informix data types convert to Oralce datatypes Stored procedures Are you using Informix Fragmentation ? This just the tip of the Iceberg. But hopefully you get some ideas and send more information. You get the general idea.Very sad that you are migrating from Informix to Oracle. Well actually criminal but IBM please take note my job market is fast disappearing and I dislike retraining :-) Traveller btnaidu@yahoo.com (Triveni) wrote in message news:<ee43e368.0409052225.516eec4d@posting.google.com>... > Hi, > How much time does it take to migrate 60GB of data from Informix > database to Oracle database. > > > Regards, > Triveni