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



Oracle LazyDBA home page