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