On Wed, 24 Aug 2005 16:15:19 +0200, "Martijn Tonies"
<m.tonies_at_upscene-removethis.nospam.com> wrote:
>Hi there,
>
>I've checked the docs, but the only limitation I can find about
>FKs is related to clustering.
>
>From the SQL Syntax doc, I figured the below should be possible:
>
>alter table scott.child
>add constraint fk_child_child
>foreign key (parentid) references northwind.parent (id)
>
>
>I was logged in with "system" and I can select from "northwind.parent",
>but the statement above kept on returning:
>ORA-00942: table or view does not exist
>
>Is this possible, or isn't it?
>
grant references on owner_of_table_to_reference.table_name to
owner_of_table_referencing.
.......
We use Oracle 8.1.7.4 and 9.2.0.6/7 on Solaris 2.7 and RH4
remove NSPAM to email
Received on Thu Aug 25 2005 - 14:52:45 CDT
