Invalid audit public synonyms
Hi team,
I have decided to use traditional audit in our 12.1.0.2.0 database. I have successfully moved $AUD and FGA_LOG$ to a new SYSAUD tablespace by using DBMS_AUDIT_MGMT :
exec DBMS_AUDIT_MGMT.set_audit_trail_location(audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,audit_trail_location_value => 'SYSAUD');
exec DBMS_AUDIT_MGMT.set_audit_trail_location(audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_FGA_STD,audit_trail_location_value => 'SYSAUD');
And i have checked those tables together with indexes are in new tbsp SYSAUD now.
My problem is that now i do have 2 public synonyms which are in status invalid, DBA_FGA_AUDIT_TRAIL and DBA_COMMON_AUDIT_TRAIL. I have tried to compile them but i get errors: