Re: Data migration from informix to oracle 10g R2

From: chijar <>
Date: Fri, 28 Dec 2007 13:16:27 -0800 (PST)
Message-ID: <>

On 28 dic, 13:53, Frank van Bortel <> wrote:
> chijarwrote:
> > On 27 dic, 15:38, Frank van Bortel <> wrote:
> >> chijarwrote:
> >>> Source: Informix
> >>> Target: Oracle 10gR2 std Edition / LINUX RHEL AS v.4
> >>> Dear all,
> >>> i have to migrate data from several plain text files corresponding,
> >>> each one of them, from INFORMIX tables.
> >>> I dont have access to informix database. The information will be in
> >>> text files and this data will be sending periodically, and the total
> >>> data size of plain text files is about 30Gb. monthly.
> >>> So, i must to do something in order to upload data (the data model is
> >>> the same than source) and I will thinking migrate with sqlloader.
> >>> Would you give me a light about that?
> >>> Is fine or bad? or
> >>> What another way do you give me in order to upload data?
> >>> Please apologize my english and thanks a lot for your answers.
> >>> cesar.
> >> Will work just fine. It is the same method, the Migration
> >> Workbench will use - but that also generates the sql*loader
> >> control files. Watch out for large objects!
> >> Just tell me - how do you plan to do the migration?
> >> The is a certain time when the Informix goes down, data
> >> needs to be moved, and Oracle comes up.
> >> --
> >> Regards,
> >> Frank van Bortel
> >> Top-posting is one way to shut me up...- Ocultar texto de la cita -
> >> - Mostrar texto de la cita -
> > =) Thanks for your answer dear friend.
> > But when you said "Watch out for large objects!" ... Would you refer
> > to Workbench or sql*loader? and why? if i suppose this tools is
> > prepared for little and large objects !!
> > How do i plan my migration?
> > well, i think something like that:
> > - i receive the plain text.
> > - upload the files to the tables in oracle
> > - i see the results.
> > That's all ??? is that ok?
> LOBs - not supported by Informix (call them Memo?).
> Cannot be loaded directly by SQL*Loader, can be handled,
> but it's a bit of a hassle.
> As to the migration it self: you seem to migrate data
> asynchronously - at some point in time, your Informix system
> needs to be shutdown - how do keep track of changes since your
> last load into Oracle?!?
> --
> Regards,
> Frank van Bortel
> Top-posting is one way to shut me up...- Ocultar texto de la cita -
> - Mostrar texto de la cita -

Thanks for your answers my dear friends... ...but it looks that i don't explain well... Let see...
Enterprise 1: send me 23 plain text files monthly and this files contains a lot of rows, sometimes this files could contain millions of rows. Each file corresponding to one table. This files have 30 Gb of total size, that means that one file could have 2Gb or 1Gb of size. I don't have any type of access to source database (informix).

Enterprise 2: (my office): after i receive files, i have to upload this data to my database (with workbench, sqlloader, or ┐external files?)

The purpose of this oracle database (target), is only, and only selects, neither DML. i didnt' have the point of indexes and i don't think that enterprise 1 send me index. Or do you recommend me that i should ask for indexes DDL scripts? and what another things i should to ask ?

The data type is only char, varchar, and integer data, all tables will belonging to one schema.

I hope it was clearly. and i appreciate a lot your help. cesar.
Please apologize my english. Received on Fri Dec 28 2007 - 15:16:27 CST

Original text of this message