Re: tablespace auto extend

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Wed, 20 Jan 1999 16:55:48 +0800
Message-ID: <36A59A14.3D69@bhp.com.au>

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
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Ugh !

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
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad"

• Salvador Dali

Received on Wed Jan 20 1999 - 02:55:48 CST