Database Administration (MOSC)

MOSC Banner

unable to move audit table to new tablespace

edited Feb 27, 2014 10:27PM in Database Administration (MOSC) 6 commentsAnswered

Hello All,

Since we are having problem when AUD$ table when it is filling SYSTEM tablespace, we'd like to move it to SYSAUX or to anyother new tablespace. Version we are using is Oracle 10.2.0.5.8. We have created PL/SQL procedure and also scheduled through sys.dbms_scheduler.create_job and is scheduled to run every Sunday at 11:30AM. It's running successfully without any issues and are clearing the data older to 90 days (as per retention agreed with customer).

Now when we are trying to move to SYSAUX it is giving following error -

SQL> BEGIN

  DBMS_AUDIT_MGMT.set_audit_trail_location(

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