Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Constraints. Synonyms , remote db.
Hi,
My project:
One database containing common data.
Several other enterprise databases sharing the common-data database.
Linking common-data database into enterprice databases using database link and synonyms.
My question is: Can I use foregn key (pk in common db) constraints on enterprise database tables, using the same syntax (using synonyms) as if the tables referensing to in FK constraint where in the same enterprise db?
Any precautions to be taken?
Kind regards,
Teo
-- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/Received on Fri May 07 2004 - 05:04:27 CDT
![]() |
![]() |