2 Replies Latest reply: Feb 14, 2013 10:49 AM by 990156 RSS

    sql loader problem with point data

    990156
      I am struggling to import bulk point data.

      Example line from data file
      2     1     Highest mountain on Skye with steep faces and narrow ridges.     4     32     3001     8307     57.206116     -6.223032     992
      So its all tab deliminated
      3001 is sdo_gtype
      8307 is sdo_srid
      57.xxx is my X point
      -6.xxx is my Y point
      992 is my Z point

      I can import all of the data apart from the final section, and my loader looks like:

      GEOM COLUMN OBJECT
      (
      SDO_GTYPE INTEGER EXTERNAL TERMINATED BY X'09' ,
      SDO_SRID INTEGER EXTERNAL TERMINATED BY X'09',
      SDO_POINT_TYPE(X,Y,Z) INTEGER EXTERNAL TERMINATED BY ','
      )
      )

      Any help? I simply need it take the last three numbers and assign them to x,y,z of point_type.

      Need any more info?
        • 1. Re: sql loader problem with point data
          NoelKhan
          TSEdinburgh,

          Try
          LOAD DATA INFILE * APPEND INTO TABLE MyTable
          FIELDS TERMINATED BY X'09' TRAILING NULLCOLS
          (
               MyCol1, 
               MyCol2, 
               description,
               MyCol3,
               MyCol4,
               geom COLUMN OBJECT (
                    sdo_gtype INTEGER EXTERNAL, 
                    sdo_srid INTEGER EXTERNAL, 
                    sdo_point COLUMN OBJECT (
                         x FLOAT EXTERNAL, 
                         y FLOAT EXTERNAL,
                         z FLOAT EXTERNAL
                    )
               )
          )
          Regards,
          Noel
          • 2. Re: sql loader problem with point data
            990156
            Fantastic! Knew it was staring me in the face