Re: PCTFREE=0 and updates

Number is an inherently variable data type. So the answer is no, not if you want to avoid row migration.

Don't forget, too, that a column declared as a CHAR, but nullable, is also inherently variable. So the existence of such columns would also tend to make row migration a likely problem.

Regards
HJR

--
-----------------------------------------------
Resources for Oracle : http://www.hjrdba.com
===============================

"Robert Eden" <rmeden_at_yahoo.com> wrote in message
news:0WXs8.77499$Bk1.2956268680_at_newssvr30.news.prodigy.com...


> If I only update statically sized columns in a table ( NUMBER, CHAR (not

> VARCHAR)) can I sent PCTFREE to 0 to avoid the (default) 10% waste? (no

> nulls involved)

>

> The Oracle docs aren't clear on the types of operations  that change "row

> size".

>

> Robert

>

>