title: How skip view log on some tables into materialized view for doing fast refresh
body: <p>There is a query where some tables are joined with each other. Due to performance and response time, a materialized view with <code>fast refresh on commit</code> is created on it like this:</p>
  
  <pre><code>create materialized view mat_calc
  refresh fast on commit
  as
  select po.title as post_title
         po.rowid as post_rowid
         c.title as comment_title,
         c.rowid as comment_rowid,
         p.title as person_title,
         p.rowid as person_rowidو
         cp.rowid as cp_rowid
    from post po, comment c, person p,post_comment_person cp
   where po.id = cp.post_id
     and c.id = cp.comment_id
     and p.id = cp.person_id  
  </code></pre>
  
  <p>As you know prerequisite for creating it is <code>materialized view log</code> on each of tables that are into this materialized view like this:</p>
  
  <pre><code>create materialized view log on post;
  create materialized view log on comment;
  create materialized view log on person;
  create materialized view log on post_comment_person;
  </code></pre>
  
  <p>As you again know, <code>the materialized view log</code> is to detect change of these tables and apply change to materialized view.<br />
  My problem is that the change of <code>post_comment_person</code> table <strong>only</strong> affects my materialized view, due to this fact it is not necessary to create <code>view log</code>  on the other three tables; another hand I want that only <code>post_comment_person</code> can to refresh not other, but it is impossible and the following error is raised:</p>
  
  <blockquote>
    <p>ORA-23413: table "person" does not have a materialized view log.</p>
  </blockquote>
  
  <p>How can it be done because the change of <code>person</code> and <code>post</code> and <code>comment</code> tables do not matter.</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>Another hand again I want to submit change to the my MV including the change of person and comment and post when a record is inserted to and deleted of post_comment_ person</p>