Skip to Main Content

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Support function-based indexes on [Abstract datatypes] (edited)

User_1871Jun 10 2022 — edited Jul 8 2022

It would be helpful if FBIs were supported on ~object datatypes~ [Abstract datatypes] (edited).
Currently, that doesn’t seem to be possible:

create index lines_fbi_sdo_idx on lines (id, startpoint_sdo_geom(shape));

ORA-02327: cannot create index on expression with datatype ADT
02327. 00000 -  "cannot create index on expression with datatype %s"
*Cause:    An attempt was made to create an index on a non-indexable
           expression.
*Action:   Change the column datatype or do not create the index on an
           expression whose datatype is one of  VARRAY, nested table, object,
           LOB, or  REF.

Comments

Post Details

Added on Jun 10 2022
11 comments
554 views