Re: Problem with ALTER TABLE

J-P Korkiakoski wrote:
>
> I am using SQL plus (release 3.1.3.7.1) with Oracle7 database.
> I am trying to change constraints in an existing table using
> alter table TABLENAME modify.... but i get an error message saying
> "ORA-02253: constraint specification not allowed here" although
> i have checked the syntax abt a million times. Does someone
> know what's the problem ?
> (I am trying to set primary and foreign keys for the table.)
>
> Thanks,
>
> Petteri Korkiakoski
The reason you are getting that message is that you can only use that statement to modify a column, ie. ALTER TABLE MODIFY (COL1 VARCHAR2(9)). You might need to use ALTER TABLE DROP CONSTRAINT <constraint name> and ALTER TABLE ADD CONSTRAINT <constraint name>. Received on Thu Jul 25 1996 - 00:00:00 CEST