oracle的表约束

--查看去约束情况
  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;