Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Free space and extents [ora8i]
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/M2Received on Tue Feb 14 2006 - 13:22:58 CST