Hi to all,
I need to migrate the data from one database to another one with out using the (SQL loadere tools).I need to support the three types of Databases they are Oracle,MS-SQL server, Boreland JDatastore.
I wrote the code it works fine. but i need to handle the Tera bytes of data, at the time the result set might throw the out of memory error.
please help me to handle this situation.
> Hi to all,
> I need to migrate the data from one database to
> another one with out using the (SQL loadere tools).I
> need to support the three types of Databases they are
> Oracle,MS-SQL server, Boreland JDatastore.
> I wrote the code it works fine. but i need to handle
> the Tera bytes of data, at the time the result set
> might throw the out of memory error.
> please help me to handle this situation.
So you are working with terabytes of data - that would most certainly mean one of 2 things. You are either someone who has almost no idea what is needed to handle this amount of data (Ie way too inexperienced) in which case you should be looking for professional help - a subset is you are dreaming really big). The other possibility is that you are a dba, in which case you would know how to trouble shoot to the point where you gave something with a little more information than it throws an out of memory error. Hopefully you aren't trying to transfer the entire thing in one shot.
