Foreign key references to tables in different schemas ?? 
Author Message
 Foreign key references to tables in different schemas ??
Does Oracle allow you to setup foreign key references to tables in a
different schema ??

If not, why not ( : ??

Matt.



Sat, 22 Dec 2001 03:00:00 GMT
 Foreign key references to tables in different schemas ??



Quote:
> Does Oracle allow you to setup foreign key references to tables in a
> different schema ??

Yes.

Quote:
> If not, why not ( : ??

Because you have not granted the "references" privilige on each relevant
table in the "foreign key" schema.

Regards,
Johan



Sat, 22 Dec 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. foreign key between tables in different table spaces

2. Foreign keys: referencing a REFERENCES doesn7t work?

3. Poor delete performance when table is referenced by a foreign key

4. foreign key referencing to more than columns in the same table

5. How to Truncate Table Referenced by Foreign Key?

6. Foreign key referencing same table.

7. Multiple references to a primary key in a foreign table

8. the replicated table is "referenced by a FOREIGN KEY constraint

9. cannot truncate table because it is being referenced by a foreign key restraint

10. How to truncate table with foreign key referenced

11. foreign key referencing its own table

12. Adding a Foreign Key Reference to a table


 
Powered by phpBB® Forum Software