Re: Problem with ALTER TABLE

From: Winston Douglas <wdouglas_at_istar.ca>
Date: 1996/07/25
Message-ID: <31F82637.E68_at_istar.ca>#1/1


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

Original text of this message