Re: ? on alter tablespace pctincrease

Connor, once again, thank you. however, another question comes to mind. I've read and was told by a consultant that if the pctincrease is set to 1 it allows
for the coalescing of free space. What are your thoughts on this?

Thanks,

Joe

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:37FDD0DB.3FBC_at_yahoo.com...
> Joe D wrote:
> >
> > Can I alter the pctincrease on a active tablespace? If so, are there any
> > conerns in doing so?
> >
> > Thanks again,
> >
> > Joe
>
> Yes you can - it won't affect any existing objects in the tablespace,
> only the new ones you create.
>
> By the way - set it to zero. Anything else is asking for grief in a
> whole lot of ways.
>
> --
> ===========================================
> Connor McDonald
> "These views mine, no-one elses etc etc"
> connor_mcdonald_at_yahoo.com
>
> "Some days you're the pigeon, and some days you're the statue."
Received on Fri Oct 08 1999 - 13:21:07 CDT