Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> alter table constraint fails
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
![]() |
![]() |