Re: PCTFREE=0 and updates

Try this:

CREATE TABLE xyz (
varfield VARCHAR2(10),
charfield CHAR(10));

INSERT INTO xyz
(varfield)
VALUES
('ABC'); COMMIT; SELECT LENGTH(varfield), LENGTH(charfield) FROM xyz;

What do you think?

Is hard disk space that precious?

Daniel Morgan

Robert Eden wrote:

> 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
Received on Wed Apr 10 2002 - 10:20:35 CDT