Re: Problem with ALTER TABLE

In article <31F7FE30.775_at_cism.bus.utexas.edu>, jaripk_at_cism.bus.utexas.edu says...
>
>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

I'm not sure of the exact syntax you used ... did you happen to see the example on p.4-125 of the SQL language ref. man.?  

It has  

alter table emp

   modify(sal number constraint nn_sal not null);

also, p4-128 has the example

alter table ship_cont
  add primary key (ship_no, container_no) disable;  

If either of these is the syntax you used, I'm not sure of the problem.  

--JP Received on Fri Jul 26 1996 - 00:00:00 CEST