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"
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.
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