From: José Antonio Morcillo Valenciano Subject: Re: pctfree and pctused Date: 2000/03/03 Message-ID: <38BF6A06.C9C3D73@gtt.es>#1/1 Content-Transfer-Encoding: 7bit References: <89jtf8$5cm$1@nnrp1.deja.com> X-Accept-Language: en Content-Type: text/plain; charset=us-ascii Organization: Telefonica Transmision de Datos Mime-Version: 1.0 Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc Sorry for my newbie question but could anyone explain easly what is pctfree and pctused! thank you! dgpare 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. > wrote in message news:89jtf8$5cm$1@nnrp1.deja.com... > > Hello, > > > > I have a huge table that only being inserted but never updated. > > Currently pctfree is 20 and pctused is 40. I would like to save some > > space by changing them to pctfree 0 pctused 100. My questions are: > > > > 1. Is the 20% free space going to be reuse for future insert? > > > > 2. How come I can't set pctused to 100? It gave me an > > ORA02211. > > > > Thanks, > > > > ewong > > > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy.