Re: Coalesce problem
From: Miguel Oliveira <nop57698_at_mail.telepac.pt>
Date: Sat, 28 Oct 2000 15:46:20 +0100
Message-ID: <8tepvh$6t6$1_at_venus.telepac.pt>
Date: Sat, 28 Oct 2000 15:46:20 +0100
Message-ID: <8tepvh$6t6$1_at_venus.telepac.pt>
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 - 16:46:20 CEST