Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL*Loader

Re: SQL*Loader

From: Rachel Carmichael <>
Date: Fri, 30 Jun 2000 17:48:15 GMT
Message-Id: <>

Having been reading the manuals lately for other SQLLoader problems, I vaguely recall a "filler field"..... you might want to research that..

sorry I don't have more specifics, but it's Friday before a holiday weekend and I managed to crack my head against the garage door yesterday evening... who am I again? :)

>To: Multiple recipients of list ORACLE-L <>
>Subject: SQL*Loader
>Date: Fri, 30 Jun 2000 09:04:33 -0800
> I hope somebody may have an idea on this. I've already done the RTFM
>and experimenting with no luck.
> My problem is that we have an automatic tester that generates ASCII
>delimited text files of it's results to be loaded to the database. One of
>files has a column in it that is no longer wanted in the database.
>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
>nothing in this results file is fixed in size. The records are from 60 to
>characters long, with trailing nullcols, and the fields therein vary from
>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
>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: (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).

Get Your Private, Free E-mail from MSN Hotmail at Received on Fri Jun 30 2000 - 12:48:15 CDT

Original text of this message