Forum Stats

  • 3,840,344 Users
  • 2,262,590 Discussions
  • 7,901,233 Comments

Discussions

ORA-02002

T1DSoldier
T1DSoldier Member Posts: 60 Blue Ribbon
edited Jan 8, 2020 9:29AM in Database Security - General

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 [email protected];

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 [email protected] where owner  in ('KDH0007');

Thanks

Dave

Message was edited by: 2718118

Best Answer

Answers