Skip to Main Content
Forums

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!

How to Drop/truncate AUDSYS.CLI_SWP$xxxxx table?

VinayakChendakeJun 6 2016 — edited Jun 6 2016

Hi All,

Oracle version : 12.1.0.1

I want to clean up the SYSAUX tablespace and this perticular table : AUDSYS.CLI_SWP$fead3aad$1$1 is consuming a lot of space.

I have tried DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL but no help.

Below info is found from the DBA_Lobs :

TABLE_NAME                     COLUMN_NAME          SEGMENT_NAME                                  INDEX_NAME                                             OWNER                    TABLESPACE_NAME

--------------------                       ------------                      -------------------------                                 --------------------                                           -----------                    --------------------

CLI_SWP$fead3aad$1$1           LOG_PIECE            SYS_LOB0000019941C00014$$           SYS_IL0000019941C00014$$                 AUDSYS                  SYSAUX

Can anyone please help?

Thanks,

Vinayak
This post has been answered by Vlad Visan-Oracle on Jun 6 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 4 2016
Added on Jun 6 2016
#database-security, #database-security-general
5 comments
6,290 views