4 Replies Latest reply on Jan 8, 2020 2:29 PM by 2718118

    ORA-02002

    2718118

      Hello,

       

      I am experiencing the below error when running a query over a db link. I can select on the remote system objects "DBA" tables and if i go over to the remote database I can select the objects schema objects fine. The privs seem fine what am i missing. I dont see any errors in the log. We are Oracle EE 12.2.0.1 linux redhat 7.4

       

      ORA-02002: error while writing to audit trail

      ORA-00942: table or view does not exist

       

      -update I am kdh0007

      privs

      grant select on kdh0007.DH_SORT_TEST to public;

       

      select * from kdh0007.DH_SORT_TEST@MED.MEDICAL.DLA.MIL;

      ERROR at line 1:

      ORA-02002: error while writing to audit trail

      ORA-00942: table or view does not exist

       

      on db with table

      select * from kdh0007.DH_SORT_TEST;

      5    A_A  
      6    A_A  
      7    B_B  
      8    B_B  

       

      works via db link

      select table_name from dba_tables@MED.MEDICAL.DLA.MIL where owner  in ('KDH0007');

       

       

       

      Thanks

      Dave

       

      Message was edited by: 2718118