删除索引报错"ORA-01418:sepecified index does not exist"
删除索引报错"ORA-01418:sepecified index does not exist"
[解决办法]
SQL> create index t on xs_kc(kch);
索引已创建。
SQL> select object_name,object_type from user_objects where object_type='INDEX' and object_name='T';
OBJECT_NAME
--------------------------------------------
OBJECT_TYPE
-------------------
T
INDEX
SQL> drop index system.t;
--用户.索引名
索引已删除。
