Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

SQL*Loader

From: <dgoulet_at_vicr.com>
Date: Fri, 30 Jun 2000 11:56:20 -0400
Message-Id: <10544.110946@fatcity.com>

    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. Received on Fri Jun 30 2000 - 10:56:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US