Re: Cannot change pctused

aprins..._at_sagetelecom.net wrote:
> I'm trying to modify pctused on a table, the alter table command does
> not return an error, but the pctused value does not get changed. I've
> tried to alter the table through GUI and with an alter command, but the
> value does not get set.
>
> I ran a SELECT * FROM USER_TABLES and it appears the pct_used value
> for all tables in the scheme are not set (null). I was under the
> impression the default for pctused was 40.
>
> Why do they all appear as null and why can I not set them?
>
> We're running Oracle9i, standard edition with locally managed
> tablespaces(does this have something to do with it?)
>
> Thx in advance

Are you using ASSM?

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14211/instance_tune.htm "Automatic segment-space management in locally managed tablespaces eliminates the need to specify the PCTUSED, FREELISTS, and FREELIST GROUPS parameters. If possible, switch from manual space management to automatic segment-space management (ASSM)."

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_3001.htm "For segments with automatic segment-space management, the database ignores attempts to change the PCTUSED setting. If you alter the PCTFREE setting, then you must subsequently run the DBMS_REPAIR.SEGMENT_FIX_STATUS procedure to implement the new setting on blocks already allocated to the segment."

Also, same document above:
"You cannot specify the PCTUSED parameter in segment_attributes for the index segment of an index-organized table."

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Wed Nov 22 2006 - 14:58:27 CST