oracle virtual index(二)
name is already used by an existing object
SQL> select index_owner,index_name from dba_ind_columns where lower(index_name)='tb1_object_id_idx';
INDEX_OWNER INDEX_NAME
------------------------------ ------------------------------
SYS TB1_OBJECT_ID_IDX
SQL> drop index tb1_object_id_idx; ---找出并删除该虚拟索引
Index dropped.