Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: foreign key between tables in different table spaces
Thx. It works nicely now
Jesper
On Fri, 18 Jan 2002 05:47:52 -0600, "Stephen Ashmore" <sashmore_at_neonramp.com> wrote:
>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 - 08:05:08 CST