Wednesday 1 May 2013

ORA-1653: unable to extend table SYS.AUD$ by 512 in tablespace SYSTEM


ORA-1653: unable to extend table SYS.AUD$ by 512 in tablespace SYSTEM

ORA-1653: unable to extend table SYS.AUD$ by 512 in tablespace SYSTEM


when I saw the allert log.

"alert.log" 
ORA-1653: unable to extend table SYS.AUD$ by 512 in tablespace SYSTEM

and even I cannot login into the DB via TOAD.


so logged into the unix server directly and invoked the sqlplus.
and then backed up the aud$ table and truncated the data in it.

SQL> select count(*) from aud$;

COUNT(*)
----------
200055


SQL> Create table aud_backup tablespace users as select * from aud$ ;

Table created.

SQL> truncate table aud$;

Table truncated.

SQL> select count(*) from aud$;

COUNT(*)
----------
0

No comments:

Post a Comment

Number of Visitors