Re: Increase max extents value

syntax is

alter table table_name
storage ( maxextents your_number);

What you need to also address at some time is the fact that the table has lots of extents and may be fragmented.

Dan

Mitchell Loren <mloren_at_home.com> wrote in message news:37BEEB3E.9C53B22C_at_home.com...
> I think that you are asking if the maxextents value on the tables can be
> changed at the ORACLE level. The PS defaults are too low once tables
> are created. (You can easily change the maxextent values in PS date
> designer and this will only change the tables defintion in PeopleSoft.
> That will not affect the table's ability to go beyond the original
> Oracle definition). You want to change that paramter without recreating
> the table. I am at home right now and don't have my dba manuals, but I
> believe it's something like "alter table TABLENAME set maxextents =
> somenumber". If that does not work you will have to recreate the table.
>
> xo55ox_at_my-deja.com wrote:
> >
> > Hi,
> >
> > I am working on some PeopleSoft table and
> > tablespace and am trying to increase the max
> > extents value at the table/index level. Since
> > PeopleSoft deals with max extents at the object
> > level even though I increased the max extents
> > value for the tablespace, it did not help. Can
> > somebody give me some help on this, please?
> >
> > Thanks in advance.
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
Received on Sat Aug 21 1999 - 15:18:14 CDT