help: import takes too long because of enable constraint

Hi, folks, we are using oracle 8172 on solaris.

I found that import of large table always takes a long time because of  constraints.

For instance, from the export dump file, I found the last two  statements:

ALTER TABLE "LIFE_NODE_XREF" ADD CONSTRAINT
"FK_NAVTECH_LNX_UPSTREAM_DSN"

FOREIGN KEY ("UPSTREAM_DASET_ID", "UPSTREAM_SECT_ID",
"UPSTREAM_POINT_ID",
"UPSTREAM_VERSION_ID", "METRO_ID")

REFERENCES "NODE" ("DASET_ID", "SECT_ID", "NAVTECH_POINT_ID", "VERSION_ID",
"METRO_ID") ON DELETE CASCADE ENABLE NOVALIDATE
and then

ALTER TABLE "LIFE_NODE_XREF" ENABLE
CONSTRAINT "FK_NAVTECH_LNX_UPSTREAM_DSN" And the longest time is the last statement, alter table ... enable  constraint ....

If the constrait is added with enable novalidate, I do not need the import utility to enable the constraint, how could I let Oracle only add the constraint enable novalidate, and do not enable constraint any more, which will save me a lot of time.

Thanks for your help.  

-- 
Sent  by joebayerii from hotmail element from com
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com/cgi/content/new