ORA-01653: unable to extend table SYSTEM.AUD$

This set of commands helped me resolve ORA-01653 quickly. First we need to find out the path to the appropriate datafile(s):

$ sqlplus sys as sysdba
SQL> select name from v$datafile where name like '%system%';

NAME
--------------------------------------------------------------------------------
/oradata/dgs3/system01.dbf

1 rows selected.

There’s only one datafile, so we’ll need to check if the /oradata (or /) has sufficient space:

$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 50G 47G 2.0M 100% /
/dev/sdg 50G 32G 16G 67% /mnt/sdg

/dev/sda1 is full, hence the error. Oracle supports multiple datafiles, so we’ll do just that:

$ sqlplus sys as sysdba
SQL> alter tablespace system add datafile '/mnt/sdg/oradata/dgs3/system02.dbf' size 1g;

Advertisements