Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Coalesce problem
the best way to recover the fragmentation space is :
1 - export the table (maje sure you have the information saved) 2 - Drop table 3 - Import the table
>Hi all!
>
>I'm quit new with the Oracle databases and would like to know what
>is the best way to find out that fragmentation of space is
>high (contiguous space on your disk appears as non-contiguous)?
>
>If I execute ALTER TABLESPACE <dbspace> COALESCE, what's happening to
>extents?
>
>Do I get more larger contiguous extents on a per tablespace basis by
>using that command?
>
>Or is there another ways to reorganisize tablespaces, except exp-imp?
>
>Thank's in forward.
>
>
>
>KT
>
>
Received on Sat Oct 28 2000 - 09:46:20 CDT