Re: Oracle Import problem.

Mark C. Stock wrote:
> "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
>
>

Just be sure that you understand what this means to your data integrity and any ramifications it can have on your application.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown