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

Home -> Community -> Usenet -> c.d.o.server -> Re: Referential Integrity Using View

Re: Referential Integrity Using View

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 06 May 2002 20:59:38 +0200
Message-ID: <sjkdduc2uo4mii6oi39dukc1pm3rr0r5ji@4ax.com>


On Mon, 6 May 2002 10:34:17 -0400, "Mark & Kristi Wagoner" <mwagoner_at_iac.net> wrote:

>Is there a way to use a view as the target of a foreign key definition? I
>created a primary key on my view but, since you must specify the DISABLE
>clause when creating it, I cannot reference it in a table's foreign key
>clause. I am using 9.0.1
>
>Thanks
>

A view is not a set, but a projection. Hence you can not have a foreign key to a view.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon May 06 2002 - 13:59:38 CDT

Original text of this message

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