The 20% Pctfree would be used for future inserts if you left it that way,
and in Oracle pctfree and pctused can not add up to 100. Try pctfree 0 and
pctused 99 if you are sure there will be no updates to the table. However if
you do this and find you are updating the table you will run into row
migration which is a new ball of wax.
<ewong_at_engineer.com> wrote in message news:89jtf8$5cm$1_at_nnrp1.deja.com...
> Hello,
>
> I have a huge table that only being inserted but never updated.
> Currently pctfree is 20 and pctused is 40. I would like to save some
> space by changing them to pctfree 0 pctused 100. My questions are:
>
> 1. Is the 20% free space going to be reuse for future insert?
>
> 2. How come I can't set pctused to 100? It gave me an
> ORA02211.
>
> Thanks,
>
> ewong
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Mar 01 2000 - 00:00:00 CST
