Tablespace issue
GauravFeb 1 2011 — edited Feb 1 2011We are getting below error
Please help on this
[GPLL]oracle@GPLL $ sqlplus /
SQL*Plus: Release 9.2.0.7.0 - Production on Tue Feb 1 05:06:39 2011
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-01653: unable to extend table SYS.AUD$ by 138254 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 138254 in tablespace SYSTEM
TABLESPACE ACT_SIZE FREE_MB %FREE USED_MB %USED LARGEST_EXTENT_MB
------------------------- ------------- ------------- ------- ------------- ------- -----------------
SYSTEM 3,550.00 798.22 22.49 2,751.78 77.51 337.65
SQL> select MAX_EXTENTS from dba_tables where owner='SYS' and table_name='AUD$';
MAX_EXTENTS
-----------
505
SQL> select count(*) from dba_extents where owner='SYS' and SEGMENT_NAME='AUD$';
COUNT(*)
----------
28