Re: Data Migratio to Oracle

->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!) \\ /________________________) (____________________________\\