审计相关
审计是安全的一部分,将有专门的文档介绍.这里将相关审计表从system表空间移到新创建的表空间上.
create tablespace audit_tbs extent management local segment space management auto;
alter table aud$ move tablespace audit_tbs;
alter index I_aud1 rebuild online tablespace audit_tbs;
alter table audit$ move tablespace audit_tbs;
alter index i_audit rebuild online tablespace audit_tbs;
alter table audit_actions move tablespace audit_tbs;
alter index i_audit_actions rebuild online tablespace audit_tbs;
--从其它地方转来的,aud$包含大字段,因此大字段也需要移走
alter table sys.aud$ move lob(sqlbind) store as( tablespace audit_tbs);
alter table sys.aud$ move lob(SQLTEXT) store as( tablespace audit_tbs);
create tablespace audit_tbs extent management local segment space management auto;
alter table aud$ move tablespace audit_tbs;
alter index I_aud1 rebuild online tablespace audit_tbs;
alter table audit$ move tablespace audit_tbs;
alter index i_audit rebuild online tablespace audit_tbs;
alter table audit_actions move tablespace audit_tbs;
alter index i_audit_actions rebuild online tablespace audit_tbs;
--从其它地方转来的,aud$包含大字段,因此大字段也需要移走
alter table sys.aud$ move lob(sqlbind) store as( tablespace audit_tbs);
alter table sys.aud$ move lob(SQLTEXT) store as( tablespace audit_tbs);
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11780477/viewspace-705074/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/11780477/viewspace-705074/