--查看去约束情况
select 'alter table '||table_name||' disable constraint '||constraint_name||' CASCADE;' as disconsql from user_constraints
where table_name = upper('t_cmp_type_mediacontent');
--查看起约束情况
select 'alter table '||table_name||' enable constraint '||constraint_name||';' as anconsql from user_constraints
where table_name = upper('t_cmp_type_mediacontent');
--查看表空间的约束情况
select segment_name,partition_name,tablespace_name from dba_extents where tablespace_name=upper('IISS_DAT');
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 =
'IISS_DAT');
--删除表空间
DROP TABLESPACE IISS_DAT INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;