Re: alter table constraint fails

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Fri, 05 Sep 2003 22:06:55 +0100
Message-ID: <anuhlvsl0eggf9ut7tipq37b00q6chv31i@4ax.com>

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 Fri Sep 05 2003 - 16:06:55 CDT