禁用Oracle中的所有表约束

-- 获取用户拥有的所有表
SELECT table_name
  FROM user_tables;

-- 禁用所有表的所有约束
DECLARE
  v_sql VARCHAR2(32767);
BEGIN
  FOR rec IN (SELECT table_name, constraint_name FROM user_constraints WHERE constraint_type IN ('P', 'U', 'C') AND owner = 'YOUR_USERNAME') LOOP
    v_sql := 'ALTER TABLE ' || rec.table_name || ' DISABLE CONSTRAINT ' || rec.constraint_name;
    EXECUTE IMMEDIATE v_sql;
  END LOOP;
END;
/