Re: Is this a bug in 9i ( FK question )

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 17 Nov 2005 18:02:04 -0500
Message-ID: <k8CdnW8lL49yluDeRVn-uQ@comcast.com>

"Rob Williamson" <robw_at_physics.umd.edu> wrote in message news:437D08B7.ADB49EA2_at_physics.umd.edu...

> SQL> @fktest
> FORIEGN KEY (item)
> *
> ERROR at line 3:
> ORA-01735: invalid ALTER TABLE option

...

>
> Here are some of the other Alter tables that actually worked:
>
> ALTER TABLE cost_history
> ADD CONSTRAINT cost_history_fk_inventory
> FOREIGN KEY (item_number)
> REFERENCES inventory ;
>

FOREIGN vs FORIEGN

Sometimes error messages tell the truth -- I hate when that happens! ;-)

Suggestions:
-- Don't top post
-- Do ignore flames

++ mcs Received on Thu Nov 17 2005 - 17:02:04 CST