oracle 系统表空间满

在用sqlplus user/password@truth登录数据库时报如下错误：
ORA-00604: error occurred at recursive SQL level 1
ORA-01653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
ORA-02002: error while writing to audit trail
ORA-00604: error occurred at recursive SQL level 1
ORA-01653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM

ORA-00604: error occurred at recursive SQL level 1的错误指的是内部的SQL语句执行失败
ORA-01653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM 意思是表空间已满

解决方法：

alter tablespace system add datafile '/home/wanson/oradata/lecake/system02.dbf' size 10M;

SYS>select FILE_NAME,TABLESPACE_NAME,STATUS,AUTOEXTENSIBLE,MAXBYTES,INCREMENT_BY from dba_data_files;

FILE_NAME                                                    TABLESPACE_NAME      STATUS    AUT   MAXBYTES INCREMENT_BY
------------------------------------------------------------ -------------------- --------- --- ---------- ------------
/home/wanson/oradata/lecake/users01.dbf                      USERS                AVAILABLE YES 3.4360E+10          160
/usr/local/inonesoft/oracle/oradata/lecake/undotbs01.dbf     UNDOTBS1             AVAILABLE YES 3.4360E+10          640
/usr/local/inonesoft/oracle/oradata/lecake/sysaux01.dbf      SYSAUX               AVAILABLE YES 3.4360E+10         1280
/usr/local/inonesoft/oracle/oradata/lecake/system01.dbf      SYSTEM               AVAILABLE YES 3.4360E+10         1280
/usr/local/inonesoft/oracle/oradata/lecake/example01.dbf     EXAMPLE              AVAILABLE YES 3.4360E+10           80
/home/wanson/oradata/lecake/users02.dbf                      USERS                AVAILABLE YES 3951034368        12800
/home/wanson/oradata/lecake/system02                         SYSTEM               AVAILABLE NO           0            0

参考于：http://charlie928.blog.51cto.com/3741218/1262979