OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Contraints-urgent

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Contraints-urgent [message #128685]

Wed, 20 July 2005 02:37

rc_ashish
Messages: 39
Registered: June 2005
Location: mumbai

Member

Hi,

I have disable contriant(P,R) by using following command,
ALTER TABLE "TEST" DISABLE CONSTRAINT "TEST_FK" CASCADE;

then i have updated data.
now I am trying to enable Constraints then it gives me error (ORA-02270: no matching unique or primary key for this column-list)

Thanks in Advance.

regards,
Ashish

Report message to a moderator

Re: Contraints-urgent [message #128691 is a reply to message #128685]

Wed, 20 July 2005 03:07

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Can you post a small test case so we can try to reproduce the problem?

$ oerr ora 02270
02270, 00000, "no matching unique or primary key for this column-list"
// *Cause: A REFERENCES clause in a CREATE/ALTER TABLE statement
//         gives a column-list for which there is no matching unique or primary
//         key constraint in the referenced table.
// *Action: Find the correct column names using the ALL_CONS_COLUMNS
//          catalog view

Best regards.

Frank

Report message to a moderator

Previous Topic:	Oracle not found
Next Topic:	error while cloning database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 08:14:56 CST 2025