查询SYSAUX表空间对应的对象占用情况：
selectowner,segment_name,segment_type,partition_name,bytes/1024/1024/1024 size_gbfrom dba_segments where tablespace_name='SYSAUX' order by size_gb asc;
清理统一审计时truncate语句会报错，解决方案如上图所示
执行以下语句
BEGIN
DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(
audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,
container =>DBMS_AUDIT_MGMT.CONTAINER_CURRENT,
use_last_arch_timestamp => FALSE);
END;
DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(
audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,
container =>DBMS_AUDIT_MGMT.CONTAINER_CURRENT,
use_last_arch_timestamp => FALSE);
END;
不过要以”/”来结束该存储过程，成功清理统一审计这张表.
| 欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) | Powered by Discuz! X3.2 |