Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is this a bug in 9i ( FK question )
"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message
news:k8CdnW8lL49yluDeRVn-uQ_at_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
>
with apologies to David Fitzgerald ...
After taking a look at David's 'arrogant' response, and Rob's reaction to it, I need to change those suggestions to:
(again, David, sorry I impugned you before checking what Rob was referring to)
++ mcs Received on Thu Nov 17 2005 - 17:07:44 CST