dos2unix sqlldr导数据

txt：

 SHANGHAI|
#1|
#277|
#华东理工大学奉贤校区|
#|
#121.499788|
#30.833079|
#121.496649 30.827363;121.491823 30.83354;121.496202 30.836245;121.501608 30.839218;121.507753 30.832792;121.499687 30.828341;121.497073 30.826941;121.496649 30.827363|
#2003|
#4326|
#1|1003|1|/
#121.496649|30.827363|121.491823|30.83354|121.496202|30.836245|121.501608|30.839218|121.507753|30.832792|121.499687|30.828341|121.497073|30.826941|121.496649|30.827363|/
 SHANGHAI|
#2|
#263|
#旅游高等专科学院|
#|
#121.508105|
#30.835153|
#121.507797 30.833172;121.505893 30.835286;121.50547 30.835946;121.509067 30.837168;121.51074 30.834212;121.507951 30.833139;121.507797 30.833172|
#2003|
#4326|
#1|1003|1|/
#121.507797|30.833172|121.505893|30.835286|121.50547|30.835946|121.509067|30.837168|121.51074|30.834212|121.507951|30.833139|121.507797|30.833172|/
 SHANGHAI|
#3|
#294|
#上海市工会管理干部学院|
#|
#121.410326|
#30.908986|
#121.408672 30.906757;121.407721 30.910625;121.411796 30.911216;121.412932 30.907447;121.408672 30.906757|
#2003|
#4326|
#1|1003|1|/
#121.408672|30.906757|121.407721|30.910625|121.411796|30.911216|121.412932|30.907447|121.408672|30.906757|/

sql：

DROP TABLE CFG_MAP_SCENE;

CREATE TABLE CFG_MAP_SCENE (
  CITY      VARCHAR2(64),
  INDEX_ID  NUMBER,
  PLANET_ID NUMBER,   
  SCENE_NAME      VARCHAR2(64),
  HEIGHT     NUMBER,
  CENTROIDX NUMBER,
  CENTROIDY NUMBER,
  VMAP      CLOB,
  GEOM     MDSYS.SDO_GEOMETRY);

COMMIT;
DELETE FROM USER_SDO_GEOM_METADATA 
  WHERE TABLE_NAME = 'CFG_MAP_SCENE' AND COLUMN_NAME = 'GEOM' ;
COMMIT;

insert into user_sdo_geom_metadata(table_name,COLUMN_NAME,DIMINFO, SRID)
values(
'CFG_MAP_SCENE',
'GEOM',
MDSYS.SDO_DIM_ARRAY(
MDSYS.SDO_DIM_ELEMENT('X',120.797934,122.055879,0.005),
MDSYS.SDO_DIM_ELEMENT('Y',30.605716,31.850379,0.005)
),
4326
);

CREATE INDEX building_sidx ON CFG_MAP_SCENE(GEOM)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
parameters ('layer_gtype =polygon'); 

COMMIT;

ctl：

LOAD DATA 
 CHARACTERSET 'UTF8'
 INFILE 'scene_20180821151727.txt'
 APPEND
 CONTINUEIF NEXT(1:1) = '#'
 INTO TABLE CFG_MAP_SCENE
 FIELDS TERMINATED BY '|'
 TRAILING NULLCOLS (
   CITY,
   INDEX_ID,    
   PLANET_ID,
   SCENE_NAME,
   HEIGHT,
  CENTROIDX,
  CENTROIDY, 
  VMAP char(1000000),
   GEOM COLUMN OBJECT 
   (
     SDO_GTYPE       INTEGER EXTERNAL, 
     SDO_SRID        INTEGER EXTERNAL,      
     SDO_ELEM_INFO   VARRAY TERMINATED BY '|/' 
       (X            FLOAT EXTERNAL), 
     SDO_ORDINATES   VARRAY TERMINATED BY '|/' 
       (X            FLOAT EXTERNAL) 
   )
)