Re: Oracle Import problem.

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 3 May 2006 18:33:08 -0400
Message-ID: <hZmdnaVBjog4ssTZnZ2dnUVZ_tGdnZ2d@comcast.com>

"Martin Weber" <mweber_at_netbi.de> wrote in message news:44592e84$0$28382$4d4ebb8e_at_read.news.de.uu.net...
: ALTER TABLE tablename MODIFY constraint_name ENABLE or DISABLE;
: In PL/SQL as
: EXECUTE IMMEDIATE 'ALTER TABLE tablename MODIFY constraint_name ENABLE';
:
: But take care, you might never enable the constraint again, while the
: constraint is violated.
:

you can always use the NOVALIDATE option when enabling a constrant that has violations

++mcs Received on Wed May 03 2006 - 17:33:08 CDT