Re: alter table constraint fails

From: Michael Hill <hillmw_at_ram.lmtas.lmco.com>
Date: Mon, 08 Sep 2003 09:52:17 -0500
Message-ID: <3F5C97A1.912DA556@ram.lmtas.lmco.com>

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 - 09:52:17 CDT