unable to move audit table to new tablespace
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(