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

Home -> Community -> Usenet -> c.d.o.misc -> Q:SQL Loader and filler cols

Q:SQL Loader and filler cols

From: Ralf Bender <ralf.bender_at_arcor.de>
Date: Wed, 19 Feb 2003 20:51:23 +0100
Message-ID: <oprkuxfxmtr3iuw7@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 - 13:51:23 CST

Original text of this message

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