Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Q:SQL Loader and filler cols
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