| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL*Loader
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? :)
>From: dgoulet_at_vicr.com
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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
>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).
 |
 |