oracle10g与11g将审计表迁移到其他表空间上

在日常的数据库维护中，经常出现因为数据库登录审计的功能启动,导致SYSTEM表空间被用满.从而出现异常,一般建议把AUD相关对象迁移到其他表空间,从而避免SYSTEM被用完的风险. -----10G及以前迁移方法 ALTER TABLE AUDIT MOVE TABLESPACE USERS;
ALTER TABLE AUDIT_ACTIONS MOVE TABLESPACE USERS;
ALTER TABLE AUD$ MOVE TABLESPACE USERS;
ALTER TABLE AUD$ MOVE LOB(SQLBIND) STORE AS SYS_IL0000000384C00041$$ (TABLESPACE USERS);
ALTER TABLE AUD$ MOVE LOB(SQLTEXT) STORE AS SYS_IL0000000384C00041$$ (TABLESPACE USERS);
ALTER INDEX I_AUDIT REBUILD ONLINE TABLESPACE USERS;
ALTER INDEX I_AUDIT_ACTIONS REBUILD ONLINE TABLESPACE USERS;
-----11G以后 可以使用DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION进行迁移
CONN / AS SYSDBA
BEGIN
DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION(AUDIT_TRAIL_TYPE => DBMS_AUDIT_MGMT.AUDIT_TRAIL_DB_STD,
AUDIT_TRAIL_LOCATION_VALUE => ‘USERS’);
END;
/