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@snap_dblink

The matter is that Oracle complains that VW_LINKS_155@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