Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data migration from informix to oracle 10g R2

chijarDec 27 2007 — edited Jan 2 2008

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.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 30 2008

Added on Dec 27 2007

#database-and-application-migrations

2 comments

2,838 views