Free space 
Author Message
 Free space
Hello,
How can i move free contigus space in the end of a tablespace.
Please help me, I haven't got any space in my disk and oracle don't use the
free space in the begin of my tablespace.


Sun, 23 May 2004 23:07:45 GMT
 Free space

Hi,

alter tablespace XXX coalesce;
startet as sys should defrag the extents in a tablespace.
Oracle 8i is said to do this automatically (, but I don't really trust :-).
Sometimes it is possible to resize the datafiles after.
If free blocks aren't used in the tablespace this should help.
If Oracle is still trying to extent the datafile the extentsize does not fit
to the free extents. Usually Oracle tries to find free extents in the existing
datafile.

Hope this helps,
    Holger

BLANC Philippe schrieb:

Quote:
> Hello,
> How can i move free contigus space in the end of a tablespace.
> Please help me, I haven't got any space in my disk and oracle don't use the
> free space in the begin of my tablespace.



Mon, 24 May 2004 06:15:28 GMT
 Free space

Quote:

>Hi,

>alter tablespace XXX coalesce;

that won't do this.  that just takes adjancent free extents in a dictionary
managed tablespace and makes them become one larger free extent.

Quote:
>startet as sys should defrag the extents in a tablespace.
>Oracle 8i is said to do this automatically (, but I don't really trust :-).

all releases do if the pctincrease for the tablespace is >0, this just makes it
happen right away.

Quote:
>Sometimes it is possible to resize the datafiles after.

nope, if you couldn't before, you cannot after.  It moves NO data.

the only way to do what they ask is to "reorg" the tablespace.  If they are
using LMT's (locally managed tablespaces) -- issueing "alter table T move
tablespace <same tablespace>" will tend to move things to the "front", they
would need to rebuild indexes as well after moving the object.

Quote:
>If free blocks aren't used in the tablespace this should help.
>If Oracle is still trying to extent the datafile the extentsize does not fit
>to the free extents. Usually Oracle tries to find free extents in the existing
>datafile.

>Hope this helps,
>    Holger

>BLANC Philippe schrieb:

>> Hello,
>> How can i move free contigus space in the end of a tablespace.
>> Please help me, I haven't got any space in my disk and oracle don't use the
>> free space in the begin of my tablespace.

--

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


Mon, 24 May 2004 20:00:49 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Oracle Free Space or Space used - DBA (now index space usage)

2. How go query Database Free Space or Used Space via T-SQL

3. Calculating used space and free space in a file

4. Free space and used space.

5. How to calculate the exact used space and free space at page level (2K)

6. How to calculate the exact used space and free space at

7. how to extract the free space and used space at page level

8. Oracle Free Space or Space used - DBA

9. Freeing Free Space

10. Unused (free) space Transaction log not freed by dbcc shrinkfile, dbcc shrinkdatabase or truncate log

11. Optimal filegroup free space

12. SQL 7 & SQL 2000 free space calculation


 
Powered by phpBB® Forum Software