Cannot change pctused

From: <aprinsloo_at_sagetelecom.net>
Date: 22 Nov 2006 12:46:52 -0800
Message-ID: <1164228412.504883.267580@m73g2000cwd.googlegroups.com>

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 Received on Wed Nov 22 2006 - 14:46:52 CST