删除表空间报错：ORA-00604 ORA-02429

drop tablespace lz including contents
*
ERROR 位于第 1 行:
ORA-00604: 递归 SQL 层 1 出现错误
ORA-02429: 无法删除用于强制唯一/主键的索引

 

处理方法：

 

删除位于该表空间的主键：

 

select 'alter table ' || owner || '.' || table_name || ' drop constraint ' ||
       constraint_name || ' ;'
  from dba_constraints
 where constraint_type in ('U', 'P')
   and (index_owner, index_name) in
       (select owner, segment_name
          from dba_segments
         where tablespace_name = 'LZ');