Oracle system01.dbf空間過大, ORA-00604, ORA-01653, ORA-02002

1. 先看看sys.aud$的空間是否過大, 或是關閉oracle audit機制
alter system set audit_trail=none scope=spfile;
shutdown immediate;
truncate table sys.aud$;
startup;

2. 調整 system01.dbf的檔案大小
alter database datafile '/usr/local/oracle/oradata/ora11g2/system01.dbf' resize 2048M;
alter database datafile '/usr/local/oracle/oradata/ora11g2/system01.dbf' auto extend on next 10M maxsize unlimited;