title: ORA-04063: view has errors
body: <p>I have 3 users (schemas) in my database.</p>
  
  <p>User A holds table X</p>
  
  <p>I created a view Y for user B and a view Z for user C.
  The views are identical:</p>
  
  <pre><code> CREATE OR REPLACE FORCE EDITIONABLE VIEW "user_name"."view_name" ("field_1", "field_2") AS 
    SELECT field1_1
  ,      field2_2
  FROM   User_A.X;
  </code></pre>
  
  <p>The first view works fine; for the second one I have the following error when trying to see data (from SQL developer):</p>
  
  <blockquote>
    <p>ORA-04063: view "User_C.Z" has errors.</p>
  </blockquote>
  
  <p>I tried to create it by SQL PLUS: it was created with compilation error, but the "show errors" command returns "no errors".</p>
  
  <p>Any suggestion?</p>