Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
hang on drop index — Cloud Customer Connect
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

Received Response
4
Views
1
Comments
edited Apr 16, 2022 7:56AM in Autonomous Database 1 comment

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!