Spatial (MOSC)

MOSC Banner

SQLLDR and Lat Lon points

edited Jan 19, 2011 4:01AM in Spatial (MOSC) 7 commentsAnswered ✓
 Hi .. I have a flat file with id, lat lon and a table with id varchar(20) and loc mdsys.geometry. I am trying to load 2 million rows and cannot seem to get my control file to work.

LOAD DATA
  infile 'nodes.csv'
  into table mps
  fields terminated by ','
  (name,
   geometry column object
    (sdo_point column object(lon float external, lat float external)
   ))

I have not been able to find any good examples and here are my errors :

SQL*Loader-404: Column  present more than once in MPS's INTO TABLE block.

or

SQL*Loader-466: Column GEOMETRY does not exist in table MPS.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center