Migrating 60GB data from informix to oracle

Posted in 2004

Triveni — 6 Sep 2004 01:01:41 -0700 — source: Usenet: comp.databases.informix

Hi, Can you pl let me know how much time it takes for 60 GB data to be migrated from informix database to oracle dataase. Regards, Triveni

↪ replying to Triveni

scottishpoet — 6 Sep 2004 09:44:53 -0700 — source: Usenet: comp.databases.informix

triveni, unfortuately there is no answer to this question. There are 2 many other factors. here are a few 1/ 60GB.. is that raw data, or including indexes? When you unload the database you won;t unload the indexes. 2/ How many disks are you unlaoding from and to how many devices (disk or tape)? 3/ What are the speeds of these devices 4/ how many processors do you have? 5/ what speeds are the processors 6/ are you unloading every table serially or have you some parallelism incorportaed in the unload? 7/ .... 12/Similar questions on the system you are loading into 13/ do all the data types exist in oracle? or are you going to need to do some data conversion in theprocess? thats a few of the things you need to consider btnaidu@yahoo.com (Triveni) wrote in message news:<ee43e368.0409060001.b2881b3@posting.google.com>... > Hi, > Can you pl let me know how much time it takes for 60 GB data to be > migrated from informix database to oracle dataase. > > > Regards, > Triveni