create materialized view

From: <fmarchioni_at_libero.it>
Date: 10 Feb 2005 03:06:47 -0800
Message-ID: <1108033607.390971.139250@o13g2000cwo.googlegroups.com>

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 Received on Thu Feb 10 2005 - 05:06:47 CST