sql loader
pacossSep 26 2006 — edited Sep 26 2006hi
i have to load data into table using sql loader. metadata and data itself are contained in the same .ctl file. these are the parameters used to invoke sql loader:
C:>sqlldr control=D:\temp\load_kat_opcin.ctl,
log=sample.log, bad=baz.bad, data=D:\temp\load_kat_opcina.ctl, userid=john/xxx11yyy@testdb, errors=999, load=2000, discard=toss.dsc, discardmax=5
when i execute this command, i get the following message:
SQL*Loader-275: Data is in control file but "INFILE *" has not been specified.
Commit point reached - logical record count 59
Commit point reached - logical record count 61
Commit point reached - logical record count 62
here is the content of my .ctl file:
LOAD DATA
INFILE *
REPLACE
CONTINUEIF NEXT(1:1) = '#'
INTO TABLE KAT_OPCINA
FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(KO_MBR NULLIF KO_MBR=BLANKS,
KO_SIFRA NULLIF KO_SIFRA=BLANKS,
KO_ID NULLIF KO_ID=BLANKS,
ID NULLIF ID=BLANKS,
KO_NAZIV NULLIF KO_NAZIV=BLANKS,
is_null1 FILLER CHAR,
POVRSINA COLUMN OBJECT NULLIF is_null1='E'
( sdo_gtype INTEGER EXTERNAL,
sdo_srid INTEGER EXTERNAL NULLIF POVRSINA.sdo_srid=BLANKS,
SDO_POINT COLUMN OBJECT NULLIF is_null1='C'
( X INTEGER EXTERNAL,
Y INTEGER EXTERNAL,
Z INTEGER EXTERNAL NULLIF POVRSINA.SDO_POINT.Z=BLANKS),
SDO_ELEM_INFO VARRAY terminated by ';' NULLIF is_null1='P'
(SDO_ORDINATES INTEGER EXTERNAL),
SDO_ORDINATES VARRAY terminated by ':' NULLIF is_null1='P'
(SDO_ORDINATES INTEGER EXTERNAL)
))
BEGINDATA
0|426|314717|6789094|MARKU[EVEC| .............
.........
0|353|14071974|6789199|TRPUCI|
#C|2003|||||1|1005|5|1|2|1|933|2|1|1955:
so, if anyone has any ideas what to do i'd be thankful !