0
CREATE INDEX test_index ON cola_markets(shape)
   INDEXTYPE IS MDSYS.SPATIAL_INDEX;

I am creating an index on Oracle Spatial column, following the guidelines here at http://docs.oracle.com/cd/B19306_01/appdev.102/b14255/sdo_objindex.htm#i78196

However, SQL developer keeps complaining about the following error. enter image description here

Weishi Z
  • 1,629
  • 5
  • 18
  • 38
  • Always a good idea to specify the exact version of your database installation (i.e. something like "11.2.0.3", not just "11g"). – Albert Godfrind Jun 16 '15 at 07:07

1 Answers1

1

That is definitely the right syntax. I confirm that there is no typing mistake by running it on my database.

On the possibility that this is some oddity due to SQL Developer, can you also try and run the command with plain sqlplus ? What do you get ?

Albert Godfrind
  • 1,978
  • 1
  • 12
  • 20