You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

hang on drop index

Question
4
Views
0
Comments
edited Apr 16, 2022 7:56AM in Autonomous Database

Summary

never end the drop command

Content

I have on the database this index 

SQL> select index_name from user_indexes;

INDEX_NAME
--------------------------------------------------------------------------------
SYS_IL0000031667C00005$$
SYS_IL0000031667C00004$$
DATI_ROMA_SEGNALAZIONI_SIDX

I'm trying to drop this index 

SQL> drop index DATI_ROMA_SEGNALAZIONI_SIDX;

but the command never end , could you explain hot to resolve .

The DDL  of index is :

CREATE INDEX DATI_ROMA_SEGNALAZIONI_sidx ON DATI_ROMA_SEGNALAZIONI(json_value(DETTAGLI_JSON, '$.geometry' RETURNING SDO_GEOMETRY ERROR ON ERROR))
  INDEXTYPE IS mdsys.spatial_index;

Version

19c

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!