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!

sql loader

pacossSep 26 2006 — edited Sep 26 2006
hi 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 !
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2006
Added on Sep 26 2006
9 comments
1,029 views