将部分数据导出后导入一个统一数据库

COL AA FORMAT A100;
set heading off;
SELECT 'ALTER TABLE ' || TABLE_NAME || ' DISABLE CONSTRAINT ' || CONSTRAINT_NAME || ';' AA
FROM user_constraints
ORDER BY constraint_type DESC;

DELETE FROM EXCEPTIONS; --删除例外表
COMMIT;
ALTER TABLE t_offering -- 找出有问题的数据
ENABLE VALIDATE CONSTRAINT FK_T_OFFERI_REFERENCE_T_CONTRA
EXCEPTIONS INTO exceptions;
DELETE FROM t_offering a WHERE a.ROWID IN 
(SELECT ROW_ID FROM EXCEPTIONS b) --删除有误的数据
COMMIT;

SELECT 'ALTER TABLE ' || TABLE_NAME || ' ENABLE CONSTRAINT ' 
|| CONSTRAINT_NAME || ';' AA
FROM user_constraints
ORDER BY constraint_type;
注释：truncate 表时，假如有子表的外键关连，不能执行该命令，
需要先禁用子表中的外键关连。
SELECT 'ALTER TABLE ' || b.table_name || ' DISABLE CONSTRAINT ' 
||b.constraint_name ||';'
FROM user_constraints a, user_constraints b
WHERE a.constraint_name = b.r_constraint_name
AND b.constraint_type = 'R'
AND a.owner = b.r_owner
AND a.table_name LIKE '''||&tablename||'''