CREATE TABLE tb_index(c1 INT,c2 INT);CREATE INDEX inde1 ON tb_index(c1);

SELECT * FROM USER_INDEXES;INDEX_NAME     INDEX_TYPE     TABLE_OWNER     TABLE_NAME      TABLE_TYPE       UNIQUENESS COMPRESSION PREFIX_LENGTH TABLESPACE_NAME     INI_TRANS    MAX_TRANS        PCT_FREE LOGGING       BLEVEL           LEAF_BLOCKS         DISTINCT_KEYS AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY STATUS                 NUM_ROWS           SAMPLE_SIZE LAST_ANALYZED         PARTITIONED TEMPORARY GENERATED VISIBILITY    DATABASE_MAINTAINED CONSTRAINT_INDEX-------------  -------------- --------------- --------------- ---------------- ---------- ----------- ------------- ------------------- ------------ ------------ ------------ ------- ------------ --------------------- --------------------- ----------------------- ----------------------- --------- --------------------- --------------------- --------------------- ----------- --------- --------- ------------- ------------------- ----------------INDE1          NORMAL         YASHAN          TB_INDEX        TABLE            N          DISABLED                0 USERS                          2          255            8 Y                                                                                                                VALID                                                                       N           N         N         VISIBLE       N                   NSELECT INDEX_NAME FROM USER_INDEXES;INDEX_NAME-------------INDE1

DROP INDEX inde1;