Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> alter table constraint fails

alter table constraint fails

From: Michael Hill <hillmw_at_ram.lmtas.lmco.com>
Date: Fri, 05 Sep 2003 15:50:56 -0500
Message-ID: <3F58F730.4C7BB5AD@ram.lmtas.lmco.com>


I am getting a ORA-00905 missing keyword

when I attempt to execute this sql

ALTER TABLE LI_ESTIMATES
 ADD CONSTRAINT XFK_EST_COST_ID FOREIGN KEY (EST_COST_ID)   REFERENCES LI_COST_CAT(EST_COST_ID)
  ON DELETE RESTRICT
  ON UPDATE RESTRICT Anyone see anything wrong with this?

Mike Received on Fri Sep 05 2003 - 15:50:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US