Hi, you have looked in all the correct places and this looks to me like a
dynamic extension issue. (i.e whatever is causing the problem is releasing
the space at the end, but during the execution of the job, it is consuming
too much of what you already have).
At least that would be my next line of reasoning based on the results you
have already shown.

I would like to see what repeated executions of your dba_free_space query
look like during the job that is failing.

Sorry if this is the wrong steer, but, you give no information on the job
that is failing with this error.

KJB

----- Original Message -----
From: "denis cloutier "
<oracledba-ezmlmshield-x32600354.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Monday, April 30, 2007 4:07 PM
Subject: 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
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>


Oracle LazyDBA home page