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.c om...
> 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

"Neil Truby" <neil.truby@ardenta.com> wrote in message news:<2q2i6nFqgl9gU1@uni-berlin.de>...
> "Triveni" <btnaidu@yahoo.com> wrote in message
> news:ee43e368.0409052225.516eec4d@posting.google.c om...
> > 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.

you forgot prep time add another 2 hrs