Re: Data Migratio to Oracle

->>->Snehal Patel <snehal@acsc.com> asked: ->>-> ->>->I need to find a way to migrate data from Informix to Oracle. ... stuff deleted ... ->>-> ->>->**Snehal Patel** ->>-><snehal@acsc.com> ->>Alan Popiel <alan@po.den.mmc.com> replied: ->> ->>The following technique worked well for me, for moving several 100K rows ->>of data from Informix to Oracle: ->> ->>1. Write Informix 4GL report programs to output data to ASCII flat files. ... more stuff deleted ... ->> ->>2. Use Oracle SQL*Loader to load the flat files into Oracle. ->> ... still more stuff deleted ... ->> ->>Hope this helps, ->>Alan ->Joseph A. Miele <news@perk.jpr.com> then asked: -> ->Why write a 4gl report when you can just run 'unload' and specify the ->delimeter you want. ->-- ->Unix at Home perk machine ->Joseph A. Miele jam@perk.jpr.com ->Dir MIS Spectraserv, Inc. 76207.1365@compuserve.com Alan Popiel <alan@po.den.mmc.com> now answers: The Oracle program SQL*Loader does a poor job of handling variable length, delimited data. On the other hand, it does a great job handling input data with fixed length fields and no delimiters. I found it a lot easier to write a simple Informix report to create fixed field length data, than to write a SQL*Loader control script to read variable length data. A second issue that affected my decision, but might not apply in your case, was that the Oracle tables did not match one-for-one with the Informix tables. My Informix reports converted the data from the Informix table structure to the Oracle table structure. Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, SLS | / \\ alan@den.mmc.com | P.O. Box 179, M/S 3810 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\