RE: SQL*Loader

I had the same problem not too long ago. I got around it in a very unimaginative way: I SQL*Loaded the data into a temporary table, then moved the data I needed over into the permanent table. Best I could come up with at the time.

Happy firecracker day!

--Walt Weaver
  Bozeman, Montana, USA

-----Original Message-----
From: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com] Sent: Friday, June 30, 2000 11:05 AM
To: Multiple recipients of list ORACLE-L Subject: SQL*Loader

    I hope somebody may have an idea on this. I've already done the RTFM thing
and experimenting with no luck.

    My problem is that we have an automatic tester that generates ASCII comma
delimited text files of it's results to be loaded to the database. One of these
files has a column in it that is no longer wanted in the database. Regrettably
it's going to be some time before the test engineering folks get around to removing it from the file, but the engineers want it out like yesterday and wouldn't you know it's right in the middle of each line. The headache is that
nothing in this results file is fixed in size. The records are from 60 to 80
characters long, with trailing nullcols, and the fields therein vary from test
to test. Even this particular column varies from 1 to 5 characters.

    Anyone out there got any idea on how to tell SQL*Loader to ignore this field??? My other alternative if Pro*C, but that may take a while too.

Thanks & Happy 4th for those of you in the States.

Dick Goulet

-- 
Author: 
  INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).