Hi - this might be a bit of a noob question but here goes. I have a table with a constraint (called FK_Category_Product) that I want to disable. When I run this statement the constraint is returned in the results:
SELECT owner,constraint_name, constraint_type, table_name, status
FROM user_constraints
WHERE constraint_type = 'R'
However when I run this statement:
alter table T_PRODUCT disable constraint FK_Category_Product
I get this error:
SQL Error: ORA-02431: cannot disable constraint (FK_CATEGORY_PRODUCT) - no such constraint
Anyone got any ideas?
Edited by: user9507427 on Mar 17, 2013 5:08 PM