loading sdo_geometry with sql loader not working
Please help. Cannot load SDO_GEOMETRY using SQLLoader.
create table SDOTEST
(
RECORD_TYPE VARCHAR2(50),
SHAPE MDSYS.SDO_GEOMETRY)
/
oracle@g:/home/oracle>cat SDO_FILE_FEED_FILE.dat
DAT:GEN:L3504330|^SDO_GEOMETRY(2002, 81989, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY(533063.704, 190967.937, 533063.532, 190967.788, 533063.002, 190967.652, 533062.772, 190967.803))
DAT:GEN:L3504350|^SDO_GEOMETRY(2002, 81989, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY(532464.568, 191058.657, 532466.082, 191059.65, 532481.692, 191064.247, 532481.434, 191066.261, 532476.516, 191082.109, 532472.981, 191093.366, 532469.912, 191099.735, 532462.726, 191107.343, 532457.724, 191110.888, 532452.819, 191113.112, 532450.968, 191113.273, 532450.595, 191112.125, 532450.623, 191111.889))
DAT:GEN:L3504409|^SDO_GEOMETRY(2002, 81989, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY(533923.917, 189061.668, 533924.02, 189061.561, 533925.163, 189049.189, 533924.415, 189047.429, 533932.444, 189050.456, 533934.147, 189051.298, 533932.476, 189053.238, 533931.251, 189070.634, 533929.536, 189092.005, 533928.538, 189101.558, 533928.513, 189102.077, 533928.613, 189102.076, 533928.273, 189110.965, 533927.832, 189124.216, 533927.616, 189127.897))
oracle@g:/home/oracle>cat SDO_TYPE_CTL.ctl
LOAD DATA
INFILE *
TRUNCATE
INTO TABLE SDOTEST
FIELDS TERMINATED BY '|^'
TRAILING NULLCOLS (
RECORD_TYPE ,
SHAPE COLUMN OBJECT
(
SDO_GTYPE INTEGER EXTERNAL,
SDO_ELEM_INFO VARRAY TERMINATED BY ')'