Recent content by Tigua

  1. T

    Compare User objects returns an error ORA-00942

    Cause of the error is missing read access on the view sys.dba_users. PL/SQL Developer is executing next query: SQL = select username from sys.dba_users union all select 'PUBLIC' username from dual order by 1 -------------------------------- Eddy Nijs Global Business Technologies
  2. T

    Compare User objects returns an error ORA-00942

    When trying to use the "Compare User Objects" I'm able connect to the target session but when I try to select the target schema next error is prompted "ORA-00942: table or view does not exist" The problem is probably related to missing privileges. Which views and tables are accessed when one...
Back
Top