Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Ices_EyesDec 22 2009 — edited Mar 11 2010
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!

Comments

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
1 person found this helpful
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
1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 8 2010
Added on Dec 22 2009
#index, #spatial, #sql-developer
8 comments
1,869 views