Re: Oracle Import problem.

From: Martin Weber <mweber_at_netbi.de>
Date: Thu, 4 May 2006 00:28:10 +0200
Message-ID: <44592e84$0$28382$4d4ebb8e@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.

"BS" <minimyme_at_yahoo.com> schrieb im Newsbeitrag news:1146691851.199575.152610_at_y43g2000cwc.googlegroups.com...
> Hi Folks,
>
> I'm trying to import the data into Oracle table using import utility.
> The error I'm getting is as below. How can I turn off the constraints
> in Oracle?
>
> IMP-00019: row rejected due to ORACLE error 2291
> IMP-00003: ORACLE error 2291 encountered
> ORA-02291: integrity constraint (FINMGR.FK_CM_COA_NUMBER) violated -
> parent key not found
>
Received on Wed May 03 2006 - 17:28:10 CDT