sqlplus / as sysdba
select segment_name,bytes/1024/1024/1024 from dba_segments where segment_name like 'AUD%';
truncate table sys.AUD$;
select segment_name,bytes/1024/1024/1024 from dba_segments where segment_name like 'AUD%';
sqlplus / as sysdba
select segment_name,bytes/1024/1024/1024 from dba_segments where segment_name like 'AUD%';
truncate table sys.AUD$;
select segment_name,bytes/1024/1024/1024 from dba_segments where segment_name like 'AUD%';