Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Free space and extents [ora8i]

Free space and extents [ora8i]

From: Morff <morff1_at_wp.pl>
Date: Tue, 14 Feb 2006 20:22:58 +0100
Message-ID: <op.s4y9gkqzq0kutt@nt_januszk.domain_not_set.invalid>


Helo

I have a tablespace for indexes . When I count a free space the result is 3,5 gb in all files (there is some files for this tablespace) but in alert log I have an information : ORA-1652: unable to extend temp segment by 14243 in tablespace T_INDEX . Is it mean that there is no space to allocate extent like that ? . Dba_free_space for this tablespace shows the biggest extent with size 70mb - should I coalesce ? (I thought oracle cares about that) ..

thanks for solutions ..

-- 
Pozdrawiam
Morff
----------------------
AQQ 141151
Powered by Opera/M2
Received on Tue Feb 14 2006 - 13:22:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US