Re: create materialized view

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 10 Feb 2005 03:44:35 -0800
Message-ID: <1108035875.087146.151570@l41g2000cwc.googlegroups.com>

fmarchioni_at_libero.it wrote:
> Hi all Oracle users !
> I'm trying to build a materialized view in
> order to import daily data from another DB
>
> CREATE MATERIALIZED VIEW VW_LINKS_155
> BUILD IMMEDIATE
> REFRESH FAST NEXT sysdate + 1
> AS SELECT * FROM VW_LINKS_155_at_snap_dblink
>
> The matter is that Oracle complains that VW_LINKS_155_at_snap_dblink (a
> remote view accessed via snap_dblink ) doesn't have a PK constraint.
>
> Forgive my ignorance but views cannot inherit PK from their tables
nor
> it's possible to target a PK on a view ?
>
> Can you give me a good advice ?
> Thanks a lot
> Francesco

Please post the exact Oracle error message/s and both source/target versions.

Regards
/Rauf Received on Thu Feb 10 2005 - 05:44:35 CST