Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Constraints. Synonyms , remote db.

Re: Constraints. Synonyms , remote db.

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Fri, 07 May 2004 13:57:56 +0200
Message-ID: <icum90thd5p6vpb59ipco71uq7ts7070dl@4ax.com>


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 DBA
Received on Fri May 07 2004 - 06:57:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US