impossible drop a PK constraint
499841Jun 7 2007 — edited Jun 13 2007Hi all,
sorry for this simple question, but I'm not a dba, but I must run this statment on the table called ANAGTELEAZIE
SQL> alter table anagteleazie disable constraint PK_CODIAZIENUMETELE;
But the error is
ORA-02431:, cannot disable constraint (string) - no such constraint.
So, on the table ANAGTELEAZIE this constraint exists!
I see it, by Enterprise Manager (but it's on the complete list of Constraints and It's not in the list of constraints of table).
So I try to insert in this table, I cannot cause this PK
My user have also dba privileges.
How can drop this constraint? (I cannot shutdown the db)
Thank's
Paolo from Madrid