Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

error: SQL Loader-466 column not exist ???

chijarJan 9 2008
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 6 2008
Added on Jan 9 2008
0 comments
1,820 views