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: Frank <fbortel_at_home.nl>
Date: Mon, 06 May 2002 22:07:13 +0200
Message-ID: <3CD6E271.7080209@home.nl>


Mark & Kristi Wagoner 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
>
>
>

Nope - a view is just that: a way of looking at data. Define on tables (what's wrong the the tables, used in the view?). So: no referential constraints on views Received on Mon May 06 2002 - 15:07:13 CDT

Original text of this message

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