Re: reset pctincrease

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1129244923.200318_at_yasure...
> niy38_at_hotmail.com wrote:
>> the original pctincrease is 50. since the last extent is too large,
>> I'm going change pctincrease to 0. is there any bad consequence of it?
>> what's the size of new allocated extent?
>
> CREATE TABLE temptab AS
> SELECT * FROM mytable;
>
> TRUNCATE TABLE mytable;
>
> ALTER TABLE mytable PCTFREE 0;
>
> INSERT INTO mytable
> SELECT * FROM temptab;
>
> But Sybrand's advice is the best. There is no excuse in 2005 to be
> working with dictionary managed tablespaces.
> --

Another possible solution :

ALTER TABLE mytable MOVE PCTFREE 0;

You need free space equal to the size of the table + you have to rebuild the table indexes and recalculate the table statistics after the move operation.

Matthias Received on Sat Oct 15 2005 - 10:27:04 CDT