ORA-01653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM系统表空间满

用普通用户连接数据库失败：系统表空间满，不能为审计表AUD$分配空间

一、提示错误：

SQL> conn user/password

ERROR:

ORA-00604: erroroccurred at recursive SQL level 1

ORA-01653: unable toextend table SYS.AUD$ by 8192 in tablespace SYSTEM

ORA-02002: errorwhile writing to audit trail

ORA-00604: erroroccurred at recursive SQL level 1

ORA-01653: unable toextend table SYS.AUD$ by 8192 in tablespace SYSTEM

 

看字面意思：在system表空间中不能扩充表SYS.AUD$

 

解决办法：此时用管理员登录 扩充表空间：

方法一：给表空间增加数据文件，并允许自动增长：

ALTER TABLESPACE SYSTEM ADD DATAFILE '/userdata/app/Administrators/oradata/ORCL/system03.dbf' SIZE5000M AUTOEXTEND ON NEXT 5000M MAXSIZE 20000M;

方法二：允许已存在的文件自动增长：

alter database datafile '/userdata/app/Administrators/oradata/ORCL/system03.dbf' AUTOEXTEND ON NEXT 500M maxsize unlimited