SQL> drop user ogg cascade; drop user ogg cascade * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-14452: attempt to create, alter or drop an index on temporary ta

1、先从user_objects中查询到该表的object_id: select object_id from user_objects where object_name=upper('XXX--表名'); 2、根据查到的object_id知道使用该表的session： select * from v$lock where id1=&object_id; 3、在从v$session视图中