title: Creating a spatial index on oracle
body: <p>I have a table 'floating_options', and I want to create a spatial index on a column 'area_geo' (which is a sdo_geometry column, with two rows of data that appear as expected when I select * from floating_options).</p>
  
  <p>I have used the following code but I am receiving the error below. I would be very grateful for any help! Thanks!</p>
  
  <pre><code>CREATE INDEX area_idx ON floating_options(area_geo)
     INDEXTYPE IS MDSYS.SPATIAL_INDEX;
  
  
  Error report -
  SQL Error: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
  ORA-13203: failed to read USER_SDO_GEOM_METADATA view
  ORA-13203: failed to read USER_SDO_GEOM_METADATA view
  ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10
  29855. 00000 -  "error occurred in the execution of ODCIINDEXCREATE routine"
  *Cause:    Failed to successfully execute the ODCIIndexCreate routine.
  *Action:   Check to see if the routine has been coded correctly.
  </code></pre>