Re: Flat File Data Load
From: Jonathan Lunn <Jonathan.Lunn_at_Canada.NCR.COM>
Date: Tue, 18 Oct 1994 14:30:33 GMT
Message-ID: <CxvHMy.B1s_at_ncrcan.canada.ncr.com>
Date: Tue, 18 Oct 1994 14:30:33 GMT
Message-ID: <CxvHMy.B1s_at_ncrcan.canada.ncr.com>
>In article <37mmol$lf5_at_theopolis.orl.mmc.com> Rob Gibson writes:
>Does anyone know how I can take a fixed field length SDF type ascii file and
>use it to insert into a an Oracle table? Sybase has a neat little utility
>called BCP that will let you import ascii data very easily. Is there something
>similar for Oracle? I looked in the FAQ, but found nothing about this. Thank
>you in advance for any light you might shed.
>
>Rob>
Rob;
Try using SQL*Loader, as documented in the Server Utilities User's Guide. I
won't
attempt to tell you all about it here, but it will do what you need.
Jonathan Received on Tue Oct 18 1994 - 15:30:33 CET