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
