error: SQL Loader-466 column not exist ??? help !!!!
From: chijar <chijar_at_gmail.com>
Date: Thu, 10 Jan 2008 12:36:44 -0800 (PST)
Message-ID: <3601b3ae-6db1-4c74-acd6-3382854578d0@z17g2000hsg.googlegroups.com>
num_paq NOT NULL CHAR(8)
formulario NOT NULL CHAR(4)
norden NOT NULL NUMBER(38)
my ctl file is:
Load DATA
INFILE file.UNL
INSERT
INTO TABLE PLANELEC.file
fields terminated by '|'
TRAILING NULLCOLS
(
)
Date: Thu, 10 Jan 2008 12:36:44 -0800 (PST)
Message-ID: <3601b3ae-6db1-4c74-acd6-3382854578d0@z17g2000hsg.googlegroups.com>
dear all.
i have a problem with sql loader.
The error is:
SQL*Loader-466: Column NUM_PAQ does not exist in table PLANELEC.file
i saw desc table:
SQL> DESC PLANELEC.file
Nombre żNulo? Tipo
----------------------------------------- -------- ----------------------------
num_paq NOT NULL CHAR(8)
formulario NOT NULL CHAR(4)
norden NOT NULL NUMBER(38)
cod_docide_dec NOT NULL NUMBER(38) num_docide_dec NOT NULL VARCHAR2(11) num_correl_a NOT NULL NUMBER(38) cod_docide_aseg NOT NULL NUMBER(38) num_docide_aseg NOT NULL VARCHAR2(15) cod_cat_tra NOT NULL NUMBER(38) cod_tipo NOT NULL NUMBER(38) fec_ini_perlab NOT NULL DATE fec_fin_perlab DATE cod_extincion CHAR(2) ind_envio NUMBER(38) fec_envio DATE num_ctl CHAR(6) ****************
my ctl file is:
Load DATA
INFILE file.UNL
INSERT
INTO TABLE PLANELEC.file
fields terminated by '|'
TRAILING NULLCOLS
(
NUM_PAQ,FORMULARIO,NORDEN,COD_DOCIDE_DEC,NUM_DOCIDE_DEC,NUM_CORREL_A,COD_DOCIDE_ASEG, NUM_DOCIDE_ASEG,COD_CAT_TRA,COD_TIPO,FEC_INI_PERLAB,FEC_FIN_PERLAB,COD_EXTINCION, IND_ENVIO,FEC_ENVIO,NUM_CTL
)
and the first line of the file.unl is:
00000000|0601|2000043|6|20100066603|1|1|90000001|1|20|01/02/2002|||0||
613954|
what could be the problem with that?
thanks a lot !
cesar
ORACLE 10GR2
RHEL AS V4.0
Received on Thu Jan 10 2008 - 14:36:44 CST