停掉所有表的约束限制,和所有的触发器;然后再全部起动;

[skypeople]

各位:

我需要停掉一个表空间中所有表的约束条件和触发器,然后在进行数据导入后再全部起动;

我有没有什么简便的方法可以使用;???

[lianhg]

写脚本；执行脚本

[beckhambobo]

DBMS_DDL.ALTER_TABLE_NOT_REFERENCEABLE
TABLE_NAME IN VARCHAR2,
TABLE_SCHEMA IN DEFAULT VARCHAR2,
AFFECTED_SCHEMA IN DEFAULT VARCHAR2;
/*约束失效*/
declare
cursor t_sor is
select table_name from dba_tables where OWNER='TEST';
begin
for v_sor in t_sor loop
DBMS_DDL.ALTER_TABLE_NOT_REFERENCEABLE(v_sor.table_name,'TEST','TEST');
end loop;
/
/*约束生效*/
declare
cursor t_sor is
select table_name from dba_tables where OWNER='TEST';
begin
for v_sor in t_sor loop
DBMS_DDL.ALTER_TABLE_REFERENCEABLE(v_sor.table_name,'TEST','TEST');
end loop;
/