Re: Q:SQL Loader and filler cols

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 20 Feb 2003 00:28:12 -0500
Message-ID: <v58prfr1gh7g57@corp.supernews.com>

> col2 "trim(:fil1)||','||trim(:fil2))||','||trim(:fil3))",

                                                  ^^                 ^^

Maybe one paranthesis instead of two will help? or maybe telling us what the exact error message is will help too ... unless you are really getting this error: oerr ora 10080
10080, 00000, "dump a block on a segment list which cannot be exchanged" // *Cause:
// *Action:

???

Anurag

"Ralf Bender" <ralf.bender_at_arcor.de> wrote in message news:oprkuxfxmtr3iuw7_at_news.arcor.de...
> Hi
>
> I'm using Oracle 8.1.7 on Linux. I want to load a ASCII Datafile with
> SQL*Loader. The ASCII File Columns with fixed length and all in Double
> Quotationsmarks. Looks very simpel,mmmh. There 3 columns in the file that
> must be load as 1 to an oracle column and that's my problem.
> so i define fil1 to fil3 as a filler field and concat this 3 to col2. But
> this won't run. I always get oracle errors like ORA-010080.
> Could someone tell me what I'm doing wrong.
>
> here is my control file:
>
> LOAD DATA
> INFILE '/data/demo.dat'
> replace
> into table demo
> (
> col1 position (2:8) "trim(:co1)",
> fil1 filler position(12:46),
> fil2 filler position(50:84),
> fil3 filler position(88:122),
> col2 "trim(:fil1)||','||trim(:fil2))||','||trim(:fil3))",
> col3 position (126:132) "trim(:col3)",
> col4 position(136:142)"trim(:col4)",
> col5 position(146:152) "trim(:col5)"
> )
>
> thanks ralf
> --
> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
Received on Wed Feb 19 2003 - 23:28:12 CST