Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Referential Integrity Using View
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