Re: SQL Loader question

Hi Vipul,

I try to solve such things on the OS-Level. You can first reduce the amount of space characters between columns to one (cat file1|sed s/\ \ /\ /g >file2) and the add the delimiters to the first columns to have all columns variable-lengted. (some like cat file1|sed s/\ /\>\>\<\</g >file2) Yep, it's a long and tiding task. (I've fed tables with 10million rows with this -nasty!)

For the second one - you can create your other table and push the .bad-file to this with another controlfile. (And make a backup-you won't really do this twice!)

oli.

On Thu, 14 Sep 2000, vipul desai wrote:
> Hi friends,
>
> I wanted to upload a ASCII file into the database using sql*loader. The
> format of the file is mixed, by that i mean first 10 fields are of fixed
> length and last 10 are of variable length having the delemiter as << start
> and
>
> >> end.
>
> Using single control file i want to upload the data into the database.
>
> One more thing if there is any exception or error in uploading data to
> the database it should insert the same row into other table with one field
> of the type logn. I mean without breaking into various fields it should
> append the record into other table.
>
> Can any one help on the same. If this is not possible through SQL*Loader
> and u are suggesting UTL_FILE then i think it would not be good option for
> me because filesize si 20 MB and processing with the UTL_FILE whould
> decrease the speed.
>
> Thanks
> -Vipul
>
> ____________________________________________________________________
> Get free email and a permanent address at http://www.netaddress.com/?N=1
Received on Thu Sep 14 2000 - 13:01:27 CDT