Re: REORG A TABLE ?

From: simone griffin <simonemg_at_online.no>
Date: Sat, 21 Nov 1998 17:40:53 +0100
Message-ID: <736qgk$a95$1@readme.online.no>

Hi.

You could export the table with data and grants etc., then drop it, and last import it. It is important in this case that you export the table with export parameter compress=y. This will put all your extent in one initial extent, but you will have to manualy adjust next extent.

Hope this is of any help.
Regards
Jan

pnguyen wrote in message <3650710B.128AC2FA_at_netexplorer.com>...
>Hello everyone,
>
>I have run analyze on some of the particular tables that I have.
>Most seem to have a problem of empty_block .. indicating
>wasted space due to repetitive INSERT/DELETE.
>How do I best reorganize those table to reduce the waste space ?
>
>
>thanks in advance,
>
>
>Paul
>
Received on Sat Nov 21 1998 - 10:40:53 CST