Re: reset pctincrease

niy38_at_hotmail.com wrote:
> the original pctincrease is 50. since the last extent is too large,
> I'm going change pctincrease to 0. is there any bad consequence of it?
> what's the size of new allocated extent?

CREATE TABLE temptab AS
SELECT * FROM mytable;

TRUNCATE TABLE mytable;

ALTER TABLE mytable PCTFREE 0;

INSERT INTO mytable
SELECT * FROM temptab;

But Sybrand's advice is the best. There is no excuse in 2005 to be working with dictionary managed tablespaces.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)