ORA-01653: unable to extend table SYS.AUD$ by 1024 in tablespace SYSTEM

ORA-01653:
unable to extend table SYS.AUD$ by 1024 in tablespace SYSTEM.

Solution

Login as oracle or any SQL privilege user.

  1. Connect:
    Sqlplus / as sysdba
  2. truncate table :
    truncate table  SYS.AUD$;
  3. New DB connections should be possible.

Hits: 3

Leave a Reply

Your email address will not be published. Required fields are marked *