Ora-01653: unable to extend table SYS. AUD $ by 8192 in tablespac system [Reproduced].
the following error was reported when logging on to the database with sqlplus user/[email protected]:
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 recursiv E SQL Level 1 error refers to internal SQL statement execution failure
ORA-01653: unable to extend table sys. AUD $ by 8192 in tablespace system indicates that the tablespace is full
log on to the database with sqlplus/As sysdba
first, use the following SQL statement to view the usage of the tablespace
select tablespace_name, (Bytes/1024/1024) m from dba_data_files;
the tablespace is full in two ways.
(1) Change the system tablespace data file system. DBF allocate space
alter database datafile '/u04/oradata/truth/system01.dbf' resize 5524 m;
(2) add another data file for the system tablespace
(3) Move the table in the system tablespace to the non-system tablespace
check whether there are other non-system tables in the system tablespace,
If yes, you can move it to a non-system tablespace.
alter table move tablespace tablespace_name
Oracle 11g installed the database by default and enabled the audit function, resulting in the continuous accumulation of SYS. AUD $ tables and related index data in Oracle;
If the tablespace is full, the ORA-1654: unable to extend index sys... error is reported in the Alert Log.
If you do not need the audit function, we recommend that you disable audit.
Processing Process:
1. log on to the database server as an oracle user and execute:
Sqlplus/As sysdba
2. Cancel audit and set the initialization parameter audit_trail to none.
Alter system set audit_trail = none scope = spfile;
3. Restart the database.
Shutdown immediate;
Sqlplus/As sysdba
Startup;
4. Delete audit data. oracle users log on to the database server:
Sqlplus/As sysdba
Truncate table SYS. AUD $;
Ora-01653: unable to extend table SYS. AUD $ by 8192 in tablespac System