title: Oracle error "M_ROW$$": invalid identifier when restoring a materialized view
body: <p>I tried to restore a materialized view in my DB by using the sql script. The view is correctly created but the script has failed when creating the index.
  There the sql issue:</p>
  <pre><code>  CREATE UNIQUE INDEX &quot;APP&quot;.&quot;I_SNAP$_APP_HIST_LIB_OR1&quot; ON &quot;APP&quot;.&quot;APP_HIST_LIB_ORGANES_MV&quot; (&quot;M_ROW$$&quot;) 
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
    STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
    PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
    BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE &quot;APP_DATA&quot; ;
  </code></pre>
  <p>The issue:</p>
  <pre><code>ORA-00904: &quot;M_ROW$$&quot;: invalid identifier
  </code></pre>
  <p>I don't know what is &quot;M_ROW$$&quot;.</p>
  <p>After looking on forums, the reason should be that this identifier is not present in the table
  but present in the mview log. But I don't have access to mview log.</p>
  <p>Could you please confirm me that or tell me how to solve this issue ?</p>
  <p>Thanks in advance for your help</p>