Re: Flat File Data Load
Date: Mon, 17 Oct 1994 12:38:39 GMT
Message-ID: <jshowers-1710940837180001_at_mac25.cmi.on.ca>
In article <37mmol$lf5_at_theopolis.orl.mmc.com>, gibson_at_bugs.orl.mmc.com (Rob Gibson) wrote:
> 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
sqlldr (or sqlload, whatever they decided to call it on your port ;) for single flat to single record relationships. It'll work for most circumstances, but if you need master detail or foreign key, or want to use a sequence you'll have to do a little pro*c.
Jodi. Received on Mon Oct 17 1994 - 13:38:39 CET