FW: ORA-1653: unable to extend table SYSTEM.MLOG$_AUD$ by 128 in tablespace TOOLS

FW: ORA-1653: unable to extend table SYSTEM.MLOG$_AUD$ by 128 in tablespace TOOLS

 

  


Hi, i do not understand this one: i am receiving this error ORA-1653 but i can't find out why ; here are details :

SQL> select * from dba_tablespaces where tablespace_name like 'TOOLS';

TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS------------------------------ ---------- -------------- ----------- -----------MAX_EXTENTS PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN----------- ------------ ---------- --------- --------- --------- --- ----------ALLOCATIO PLU SEGMEN DEF_TAB_--------- --- ------ --------TOOLS 8192 1048576 1048576 1 2147483645 0 1048576 ONLINE PERMANENT LOGGING NO LOCALUNIFORM NO MANUAL DISABLED



SQL> select file_name from dba_data_files;
FILE_NAME--------------------------------------------------------------------------------/var/opt/oracle/O1041/system/o1041_system.dbf/var/opt/oracle/O1041/work/o1041_undotbs01.dbf/var/opt/oracle/O1041/work/o1041_tools.dbf/var/opt/oracle/O1041/work/o1041_users.dbf/var/opt/oracle/O1041/work/O1041_drsys.dbf/var/opt/oracle/O1041/index/at001is1.dbf/var/opt/oracle/O1041/data/at001ts1.dbf/var/opt/oracle/O1041/index/at001is2.dbf/var/opt/oracle/O1041/data/at001ts2.dbf/var/opt/oracle/O1041/system/o1041_system2.dbf
10 rows selected.
SQL> ! ls -l /var/opt/oracle/O1041/work/o1041_tools.dbf-rw-r----- 1 oracle dba 454041600 Apr 30 08:57 /var/opt/oracle/O1041/work/o1041_tools.dbf

SQL> select * from dba_data_files where file_name like '%tools%';
FILE_NAME-------------------------------------------------------------------------------- FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS---------- ------------------------------ ---------- ---------- ---------RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS------------ --- ---------- ---------- ------------ ---------- -----------/var/opt/oracle/O1041/work/o1041_tools.dbf 3 TOOLS 454033408 55424 AVAILABLE 3 YES 3.4360E+10 4194302 512 452984832 55296

select bytes from dba_free_spaces where tablespace_name = 'TOOLS';
BYTES---------- 5242880 1048576 2097152 1048576 2097152 1048576 1048576 2097152 1048576 1048576 2097152 .... and more chunks of 1048576, 2097152 and 5242880


SQL> select sum(bytes) from dba_free_space where tablespace_name like '%TOOLS';
SUM(BYTES)---------- 253755392SQL> select sum(bytes) from dba_segments where SEGMENT_NAME = 'MLOG$_AUD$';
SUM(BYTES)---------- 196083712

SQL> ! df -k /var/opt/oracle/O1041/workFilesystem kbytes used avail capacity Mounted on/dev/vx/dsk/dg_b2_o1041/lv_o1041_work 3429090 1624969 1657820 50% /var/opt/oracle/O1041/work
Something's missing ?
SO why am i having this error ?



Soyez parmi les premiers à essayer Windows Live Mail.
_________________________________________________________________
Soyez parmi les premiers à essayer Windows Live Mail.
http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d
Oracle LazyDBA home page