CODEWITHSUNDEEP
oracle-database
slimsim
slimsim

Reputation: 83

Getting an invalid ALTER TABLE option

This is my exact query which is erroring out

  alter table INDIL_MCAR drop constraint ABOB.INDI_MCAR_PK;

I m trying to remove the unique key constring from the table. It gives me the following error.

 ORA-01735: invalid ALTER TABLE option

Upvotes: 3

Views: 6264

Answers (1)

sstan
sstan

Reputation: 36473

You can't prefix the constraint name... the table name yes, but not the constraint name. Remove the ABOB.:

alter table INDIL_MCAR drop constraint INDI_MCAR_PK;

Upvotes: 4

Related Questions