Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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
-- Daniel Morgan - Unregistered User ------------------------------------------------------------------------ View this thread: http://homer-w2k:7802/baanboard/showthread.php?threadid=7606Received on Wed Apr 10 2002 - 23:39:44 CDT