Originally posted by leonard905
Hi,
I'm trying to disable a constraint but I get this error message anytime I issue the command:
SVRMGR> alter table om_account disable constraint OM.SYS_C00922;
ALTER TABLE schema.object_name
DISABLE CONSTRAINT schema.constratint;
In your case it looks like it is a primary/unique key constraint. So it would be
ALTER TABLE schema.table_name
DISABLE PRIMARY KEY;
ALTER TABLE schema.table_name
DISABLE UNIQUE (col1, ...) CASCADE;
Hope this would help you. I could be wrong in the syntax assumption ...
Sam
Thanx
Sam
Life is a journey, not a destination!