Database Administration (MOSC)

MOSC Banner

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:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center