Oracle审计表AUD$处理方法
Oracle版本:11.2.0,其他版本要测试DBMS_AUDIT_MGMT能否成功
1. 查询表,然后truncate
select count(*) from aud$;
truncate table aud$;
select count(*) from aud$;
2.创建表空间
create tablespace adttbs
datafile '/oracle/OMT/admin/oradata/aud01.dbf' size 2G autoextend on;
SELECT table_name, tablespace_name
FROM dba_tables
WHERE table_name IN ('AUD$&#