Re: tablespace datafiles only filled up to 50%

In article <20010808.20231769_at_mis.configured.host>, Ralf says...
>
>hi
>
>i got one tablespace with 4 datafiles. two of that files only filled up =
>
>to 50%, but oracle says they are full. what's going wrong here? how can =
>i=20
>say oracle to use all availible space in files?
>
>thx
>ralf

it is more likely saying that it cannot allocate an extent of the requested size. The free space in your tablespace is most likely fragmented, a result of using non-equi sized extents.

See
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:285415955510

for a script that will show you the free space by tablespace as well as the largest CONTIGOUS chunk of free space by tablespace. that'll be the biggest NEXT or INITIAL extent you can use in there.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp