Thank you very much, It helps.

Peter

-----Original Message-----
From: Steve Eliappa [mailto:Steve.[Email address protected]
Sent: 2006. augusztus 2. 15:50
To: Péter Csák
Subject: RE: not existent unique key constraint cause error

Peter,

When a Unique constraint is created, it would have created an Index. You got to drop the index as well.

Steve

-----Original Message-----
From: Péter Csák [Email address protected]
Sent: 02 August 2006 14:35
To: LazyDBA Discussion
Subject: not existent unique key constraint cause error

Hi!

I've deleted a unique key constraint UQ_CONTENT.
After it I've tried to insert a row to the table with an existent value on the specified field and oracle error occurred:
ORA-00001: unique constraint (CONTENT_HOST.UQ_CONTENT) violated.

I've tried from another machine, resulted the same error.

After it I tried to find it with:
SELECT * FROM ALL_CONSTRAINTS WHERE CONSTRAINT_NAME LIKE '%UQ_CONTENT';

And

SELECT * FROM ALL_CONSTRAINTS WHERE CONSTRAINT_NAME LIKE 'UQ_CONTENT';

Each resulted 0 rows.

What's happened? How can I delete the constraint?

Thank you in advance:
Peter




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html



______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________





Oracle LazyDBA home page