SQL Loader-350 Token longer than max allowable length of 258
563850Jun 17 2010 — edited Jun 17 2010Hi all,
who can help me with this error:
My clt:
load data
infile 'micromedicao.medicao_historico.csv'
into table medicao_historico
fields terminated by "|" optionally enclosed by '"'
TRAILING NULLCOLS
(
MDHI_ID
,IMOV_ID
,MEDT_ID
,MDHI_AMLEITURA
,MDHI_NNXCONSECANORMALIDADE
,MDHI_DTLEITANTFATMT "decode(:MDHI_DTLEITANTFATMT, null , null, to_date( :MDHI_DTLEITANTFATMT , 'yyyy-mm-dd' ) )"
,MDHI_NNLEITANTFATMT
,MDHI_NNLEITANTINFORMADA
,MDHI_DTLEITURAATUALINFORMADA "decode(:MDHI_DTLEITURAATUALINFORMADA, null , null, to_date( :MDHI_DTLEITURAATUALINFORMADA , 'yyyy-mm-dd' ) )"
,MDHI_NNLEITURAATUALINFORMADA
,MDHI_DTLEITURAATUALFATURAMENTO "decode(:MDHI_DTLEITURAATUALFATURAMENTO, null , null, to_date( :MDHI_DTLEITURAATUALFATURAMENTO , 'yyyy-mm-dd' )
,MDHI_NNLEITURAATUALFATURAMENTO
,MDHI_NNCONSUMOMEDIDOMES
,MDHI_NNCONSUMOINFORMADO
,FUNC_ID
,LTAN_IDLEITANORMINFORMADA
,LTAN_IDLEITANORMFATMT
,LTST_IDLEITURASITUACAOATUAL
,LTST_IDLEITURASITUACAOANTERIOR
,MDHI_TMULTIMAALTERACAO "to_timestamp(:MDHI_TMULTIMAALTERACAO, 'yyyy-mm-dd hh24:mi:ss.ff6' )"
,HIDI_ID
,LAGU_ID
,MDHI_DTLEITPROCESSAMENTOMOV "decode(:MDHI_DTLEITPROCESSAMENTOMOV, null , null, to_date( :MDHI_DTLEITPROCESSAMENTOMOV , 'yyyy-mm-dd' ) )"
,MDHI_NNCONSUMOMEDIOHIDROMETRO
,MDHI_NNLEITURACAMPO
,LEIT_ID
,USUR_IDALTERACAO
,MDHI_ICANALISADO
,MDHI_DTLEITURACAMPO "decode(:MDHI_DTLEITURACAMPO, null , null, to_date( :MDHI_DTLEITURACAMPO , 'yyyy-mm-dd' ) )"
,MOTP_ID
)
Now loader command:
sqlldr micromedicao@gsan/micromedicao control=micromedicao.medicao_historico.clt
and get this erro:e
SQL*Loader: Release 10.2.0.4.0 - Production on Thu Jun 17 15:49:18 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL*Loader-350: Syntax error at line 23.
Token longer than max allowable length of 258 chars
,LTAN_IDLEITANORMFATMT
^
This appear an bug..
Version : oracle 10.2.0.4.0
O.S : rhel 5