pct_increase is null

8.1.7 on windows 2K professional.

Hello All,
I have been examining dba_tables on an instance in preparation for migration to 9.2. The curious thing is that the pct_increase value is null for all tables in the (third party) user schema. No errors appear in the logs. I must admit I'm at a loss as to how exactly this came about: AFAIK alter table (storage pctincrease) will not accept null. It's possible that someone (another dba) modified the data dictionary. I propose altering the value to 0 using alter table...

Do you have any comments on:

a) the possible cause of the null values
b) my proposed solution
c) how on earth the instance is still upright??

TIA
Anthony Hogan Received on Wed Sep 15 2004 - 07:52:05 CDT