Re: foreign key between tables in different table spaces

From: Stephen Ashmore <sashmore_at_neonramp.com>
Date: Fri, 18 Jan 2002 05:47:52 -0600
Message-ID: <u4g2r42h288u01@corp.supernews.com>

Grant reference to the user.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

"Jesper Abrahamsen" <jabr35_at_yahoo.dk> wrote in message news:3c47f7e4.13130009_at_read.news.be.uu.net...
> I am trying to create a foreign key between columns in two tables
> which have different owners.
>
> I have tried to execute the alter table command
> alter table owner1.table1 add (
> CONSTRAINT constraint1 FOREIGN KEY (col_in_table1)
> REFERENCES owner2.table2 (col_in_table2))
> /
>
> I have tried to give insert,select,delete,update and alter to owner1
> on table2, but I contimnue to get
>
> ERROR at line 3:
> ORA-01031: insufficient privileges
>
> any idea ?
>
> Thx
> Jesper Abrahamsen
Received on Fri Jan 18 2002 - 05:47:52 CST