ORA-02429: 无法删除用于强制唯一/主键的索引

drop tablespace时碰到报错

原因由于主键约束，需要先删除约束

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 = 'TBS_LVES');