foreign key between tables in different table spaces

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 - 04:30:49 CST