Sorry if I gave you the wrong information, Yong is correct.
D Parent
<yong321_at_yahoo.com> wrote in message news:89kter$sch$1_at_nnrp1.deja.com...
> Technically you *can* set pctfree and pctused such that they add up to
> 100. Try it. It works. But it's never a good idea. However, whatever
> number you use, it has to be an integer between 0 and 99, inclusive. 100
> is not allowed in spite of Oracle documentation (at least on my Ver.
> 8.0.5 NT)
>
>
> --
> Yong Huang
>
> (yong321_at_yahoo.com)
> (http://www.stormloader.com/yonghuang/)
>
> In article <VMjv4.4032$Xk2.24493_at_tor-nn1.netcom.ca>,
> "dgpare" <dgpare_at_netcom.ca> wrote:
> > 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.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Mar 02 2000 - 00:00:00 CST
