Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Constraints. Synonyms , remote db.
On Fri, 07 May 2004 12:04:27 +0200, "Dev.dep" <tmp_at_jaertek.no> wrote:
> 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?
No,. you can't. Foreign keys can not exist to linked tables. If you would have tried it you would have gotten an error message stating so.
-- Sybrand Bakker, Senior Oracle DBAReceived on Fri May 07 2004 - 06:57:56 CDT
![]() |
![]() |