Re: tablespace auto extend

From: Darryl E Balaski <darryl_e_balaski_at_groton.pfizer.com>
Date: Wed, 20 Jan 1999 14:26:16 -0500
Message-ID: <36A62DD8.75C9@groton.pfizer.com>

Connor McDonald wrote:
>
> steve_young_at_my-dejanews.com wrote:
> > Hi there, I want to make my table space auto extend to unlimited. Should I
> > change the parameter for tablespace itself or change it for each individual
> > datafiles within the tablespace?
> > Thanks.
> > Steve
>
> You do it for the datafiles (just one will do)...but it opens you up to
> having sizes spiralling out of control...
> Assuming you need this for some sort of one-off load operation, I would
> strongly advise once done, you turn autoextend off again...
> Cheers
> Connor McDonald

I agree with Connor -- It can be problematic if you autoextend -- especially if you do not have the disk space. I know I will probably get flamed for this, but I consider autoextend a very poor dba practice.

dB Received on Wed Jan 20 1999 - 13:26:16 CST