btnaidu

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

dryburghj

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