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 -> Re: alter table constraint fails

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

Original text of this message

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