Problem with ALTER TABLE
From: J-P Korkiakoski <jaripk_at_cism.bus.utexas.edu>
Date: 1996/07/25
Message-ID: <31F7FE30.775_at_cism.bus.utexas.edu>#1/1
Date: 1996/07/25
Message-ID: <31F7FE30.775_at_cism.bus.utexas.edu>#1/1
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 ?
Thanks,
(I am trying to set primary and foreign keys for the table.)
Petteri Korkiakoski Received on Thu Jul 25 1996 - 00:00:00 CEST