1.创建表空间
create tablespace shenji datafile '/data2/oracle/oradata/orcl/shenji.dbf' size 1024m autoextend on next 1024M maxsize unlimited;
2.转移到新的表空间sqlplus /nolog
connect / as sysdba
alter table aud$ move tablespace shenji;alter index i_aud rebuild online tablespace shenji;
alter table audit$ move tablespace shenji;
alter index i_audit rebuild online tablespace shenji;
alter table audit_actions move tablespace shenji;
alter index i_audit_actions rebuild online tablespace shenji;