disable constraint error - Please Help!!

[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 om_account disable constraint OM.SYS_C00922
*
ORA-00933: SQL command not properly ended


Could someone please help me correct this problem.


Thanks,
Leonard905

[marist89]

try

alter table om_account modify constraint OM.SYS_C00922 disable;

See http://technet.oracle.com/docs/produ...4a.htm#2060791 and http://technet.oracle.com/docs/produ...2a.htm#2054899 for details.

[nealh]

I don't think you're allowed a username in the constraint clause. Try:

alter table om_account disable constraint SYS_C00922

[leonard905]

Thanks, though. But none of the suggestions worked. Any more suggestions.

[sambavan]

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