Re: Data Migratio to Oracle

Posted in 1994

Joseph A. Miele / News Administrator — Wed, 11 May 1994 17:12:11 GMT — source: Informix-list mailing list archive (1991-1998)

In article <2qlju2$non@emory.mathcs.emory.edu>, Alan Popiel <alan@po.den.mmc.com> wrote: >->From: snehal@acsc.com (Snehal Patel) >->Subject: Data Migratio to Oracle >->Date: 6 May 1994 21:59:35 GMT >->Reply-To: snehal@acsc.com (Snehal Patel) >->Organization: Advanced Computing Systems Company >->Sender: informix-list-owner@rmy.emory.edu >-> >->Hi! >-> >->I need to find a way to migrate data from Informix to Oracle. >->I am using an application called Workpro2.2 developed by Quintus corporation >->and it does not have any satisfactory way of doing this when we move database >->platforms. >->Any help will be appreciated. >-> >->thanks >-> >->**Snehal Patel** >-><snehal@acsc.com> > >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. > I presume ACE could be used as well, but I used 4GL. The flat files > had no headers, no trailers, no pagination. The report program also > took care of minor data conversions done at the time of the transfer. > >2. Use Oracle SQL*Loader to load the flat files into Oracle. > >I chose to have the Informix report program write the SQL*Loader control >info at the front of the flat file, using the INFILE * option. However, >it is perhaps easier to have the report program only create the data and >to hand carve the SQL*Loader control file. > >Hope this helps, >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!) \\ >/________________________) (____________________________\\ > 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