Database Administration (MOSC)

MOSC Banner

Error when initialize the cleanup of the audit tables

edited Dec 11, 2011 2:38PM in Database Administration (MOSC) 3 commentsAnswered
  Hi all,

   My db version is : 11.1.0.7.0 64 bit on Linux.
   
   I configure my db to auto purge audit data (I also test and success on same db version).

   I were create a tablespace with name is AUDIT_AUX and size is 3G (with option is AUTOEXTEND). After that, I move two tables AUD$ and FGA_LOG$ to new this tablespace and moving success, I used script to check location:

SELECT table_name, tablespace_name
FROM   dba_tables
WHERE  table_name IN ('AUD$', 'FGA_LOG$')
ORDER BY table_name;

   And result is:
AUD$                 AUDIT_AUX
FGA_LOG$        AUDIT_AUX

   After that, I initialize the cleanup of the audit tables via dbms_audit_mgmt package by script:

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