Skip to Main Content
Forums

SQL & PL/SQL

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.

Spatial index error - ORA-13209

Robert_D.Sep 18 2019 — edited Sep 19 2019

Hello,

I have problem with one of my partitioned spatial index on Oracle 12.1.0.2.0. I can't do any operation on it. I also can't rebuild it.

"ORA-29874: warning in the execution of ODCIINDEXALTER routine

ORA-29960: line 1,  Check Oracle Error <13209>

ORA-13209: internal error while reading SDO_INDEX_METADATA table

ORA-06512: at line 1

"

When I query below SQL, I get many rows with

status = USABLE

domidx_opstatus = FAILED

select * from user_ind_partitions where index_name = 'my_spatial_index' and domidx_opstatus != 'VALID';

How can I fix this?
This post has been answered by [Deleted User] on Sep 19 2019
Jump to Answer

Comments

Processing

Post Details

Added on Sep 18 2019
4 comments
702 views