Skip to Main Content

SQL Developer Data Modeler

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!

How to create Spatial index in SQL Developer Data Modeler 4

user6479601Mar 9 2015 — edited Mar 26 2015

Hi,

What is the procedure to create a Spatial index in SDDM v4 ? I ended up in a deadlock due to the following issues :

1) Reverse engineering missed the spatial index, so I need to add them manually.

2) Adding an index does not allow me to check the 'spatial index' checkbox, nor does it allow me to add the sdo_geometry column in the index definition.

3) When registering Spatial properties for a table, I cannot choose the Spatial Index name.

I came across an old post (Data Modeler - can't create a spatial indexes), yet this post is no longer valid since SDDM V4 does not allow me to create an index without columns (incomplete index definition).

Help is appreciated,

Kind regards,

Richard.

This post has been answered by David Last-Oracle on Mar 24 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 23 2015
Added on Mar 9 2015
28 comments
4,620 views