Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to clear AUDSYS.CLI_SWP$XXX table of sysaux tablespace

Preethi DBAJan 4 2018 — edited Jan 5 2018

We used to have auditing enabled in oracle 12R1 database. due to which 120GG space is occupied in AUDSYS.CLI_SWP$XXX.

 

Currently we had disabled the unified auditing and move the aud$ table to new tablespace to avoid growing of sysaux tablespace.

 

We tried to clear/purge the audsys.CLI_SWP$XXX data using the below package.

 

BEGIN

DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(

audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,

use_last_arch_timestamp => TRUE);

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 2 2018
Added on Jan 4 2018
1 comment
1,604 views