Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: pct_increase is null
"agis" <stag_at_hq.acn.gr> escribió en el mensaje
news:ci9iml$26eq$1_at_ulysses.noc.ntua.gr...
> 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
> >
> >
> >
>
>
Thanks for the reply agis,
Just to clarify: I haven't been playing with the dd, nor do I intend to.
In response to your question: the objects in question are plain tables.
A typical definition (lifted from an export) is:
CREATE TABLE TAUL (CDC VARCHAR2(5), CDU VARCHAR2(4), CDE VARCHAR2(2), CDP VARCHAR2(2)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 40960) TABLESPACE users;
regards,
Anthony Hogan
Received on Wed Sep 15 2004 - 11:05:24 CDT