title: fast refresh Materialized view with primary key based log
body: <p>I have 2 tables </p>
  
  <p><strong>car_acc</strong> with primary key <em>car_acc_id</em></p>
  
  <p>and</p>
  
  <p><strong>final_cost</strong> with primary key <em>car_acc_id</em> references the previous one.</p>
  
  <p>I have create 2 logs as:</p>
  
  <pre><code>CREATE MATERIALIZED VIEW LOG ON car_acc WITH PRIMARY KEY; 
  
  CREATE MATERIALIZED VIEW LOG ON final_cost WITH PRIMARY KEY ; 
  </code></pre>
  
  <p>I choose PrimaryKey log to solve import/export problems with ROW ID</p>
  
  <p>then I've  tried to create MATERIALIZED view on these tables as:</p>
  
  <pre><code>CREATE MATERIALIZED VIEW costs
  BUILD IMMEDIATE
  REFRESH FAST ON demand
  AS SELECT ca.car_id, ca.acc_id,f.cost
    FROM car_acc ca,final_cost f
    WHERE ca.car_acc_id=f.car_acc_id;
  </code></pre>
  
  <p>but with exception :</p>
  
  <pre><code>"cannot fast refresh materialized view %s.%s"
  *Cause:    Either ROWIDs of certain tables were missing in the definition or
         the inner table of an outer join did not have UNIQUE constraints on
         join columns.
  </code></pre>