Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: pct_increase is null
Don't play with the data dictionary !!!!!
Check if this table is IOT, temporary table ,mview or mview log
"Anthony Hogan" <ahoganXX_at_XXinerza.com> wrote in message
news:ci9dtn$aad$1_at_nsnmpen3-gest.nuria.telefonica-data.net...
> 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 - 09:13:39 CDT