如何先disable 外键约束再enable它？

[zenghongmei1]

imp出错，约束问题，我想先disable掉，imp后再enable。

[zenghongmei1]

是disable所有表，不是一个一个来。

[zhaoyongzhu]

ALTER TABLE "SCOTT"."TESTOBJECT"
DISABLE VALIDATE
CONSTRAINT "ZYZ111"

ALTER TABLE "SCOTT"."TESTOBJECT"
ENABLE VALIDATE
CONSTRAINT "ZYZ111"

[black_snail]

I guess you want to generate a script to disable all the foreign key

try this

select 'ALTER TABLE '||table_name||' disable constraint '||constraint_name||';' from user_constraints
where constraints_type = 'R'

it will output the script which you can run it to disable the FK in the current shema

[zenghongmei1]

^_^
单个表的