Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: alter table constraint fails
Never mind, I figured it out. I simply needed to define the constraint between the two tables
ALTER TABLE LI_ESTIMATES
ADD CONSTRAINT XFK_EST_COST_ID FOREIGN KEY (EST_COST_ID)
REFERENCES LI_COST_CAT(EST_COST_ID)
Michael Hill wrote:
> I can't get in there right now, can you provide some insight until I can?
>
> Appreciate that ....
>
> Andy Hassall wrote:
>
> > On Fri, 05 Sep 2003 15:50:56 -0500, Michael Hill <hillmw_at_ram.lmtas.lmco.com>
> > wrote:
> >
> > >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?
> >
> > http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/clauses3a.htm#1001967
> >
> > --
> > Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
> > Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)
Received on Mon Sep 08 2003 - 12:49:33 CDT