Re: Materialized views for 53 tables

Posted by Roshan on Jan 19, 2018; 7:17am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Materialized-views-for-53-tables-tp4943p4992.html

Hi Erman,

thanks for update.

can you please advise if primary key is necessary for each table in order to create the materialized views?

We have primary key enabled for only 20 tables. Is there a way I can bypass the primary key in he create materialized view log statement?

CREATE MATERIALIZED VIEW LOG ON scott.emp
TABLESPACE users
WITH PRIMARY KEY
INCLUDING NEW VALUES;