SQL Developer 2.1 (final but also RC and EA) - Spatial index creation error

Ices_Eyes

If you have a table with a column of type SDO_GEOMETRY, and you use the edit table editor to insert a new spatial index to the column, you get an error that say that the column type (SDO_GEOMETRY) is not suitable for a text index (who ask you for text index then :P).
This problem was present from the first version of SQL developer 2.1, and still present in the final version!!!
Very annoying!

Ices_Eyes

Up...!

Ices_Eyes

Noone is experiencing the same issue?

-K-

My suggestion is to open a SR at Metalink/MOS (if you have a database support contract), else hope someone from the team is interested in logging/debugging this through the forum.

Regards,
K.

Ices_Eyes

-K- wrote:
My suggestion is to open a SR at Metalink/MOS (if you have a database support contract), else hope someone from the team is interested in logging/debugging this through the forum.

Regards,
K.

Unfortunately I have no a support contract, so...Hoping someone of the developer read this...Maybe it will be fixed in the next release

PS: if some developer read this, please let me know, so I stop to try to mantaint this thread alive :P

Ices_Eyes

Any news about this bug?

hlaebe

Hi,
did you try GeoRaptor [GeoRaptor |http://sourceforge.net/projects/georaptor/] ? We have tools for indexing, maintaining metadata (which might be the reason for this non-support in SQL Developer, since metadata is required for indexing).

Give it a try, it is free!

Regards,
Holger

Edited by: hlaebe on 03.02.2010 08:56

Ices_Eyes

Thanks, that work! And is pretty useful too...

Ices_Eyes

By the way, this bug is still present in version 2.1.1... :-S