title: ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc
body: <p>Just trying to insert a Row in the Customer table which is not included in the Error Table. </p>
  
  <p>--View</p>
  
  <pre><code>Create View A3_SRC_CUST_VIEW As
  Select SRC_CUST_A.*, rowid as row_id From SRC_CUST_A
  Union All
  Select SRC_CUST_B.*, rowid as row_id From SRC_CUST_B;
  </code></pre>
  
  <p>-- Insert Statement</p>
  
  <pre><code>Insert Customer (DW_CUST_ID, CUSTID, CUSTNAME, CUSTEMAIL, CUSTLOC)
  Select  Dw_Cust_Id.Nextval,  v.CID,  v.NAME, v.Email, v.LOC
  From CustView v
  Where v.rowid Not In
      (Select Source_RowId From A3_Error_Event  Where Filter_Id = 4 );
  </code></pre>
  
  <p>The error I am getting is <em>ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc.
  01446. 00000 -  "cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc."</em></p>