Re: Maxsize for Set of Tablespaces in 10g and 11i?

From: HoneyMonster <someone_at_someplace.invalid>
Date: Tue, 14 Dec 2010 00:35:06 +0000 (UTC)
Message-ID: <ie6e3q$gt$1_at_news.eternal-september.org>

On Mon, 13 Dec 2010 07:40:01 -0800, if_investor_at_yahoo.com wrote:

> Hi,
>
> Is there a way, on 10g and 11i, to create a set of 4 tablespaces, each
> of which is
> set to autoextend, so that the entire set of tablespaces has a specific
> maxsize
> value?
>
> I am not interested in setting a specific maxsize value for any specific
> tablespace,
> rather, for the set as a whole.
>

Not directly within Oracle.

Far better IMHO to avoid autoextend altogether; simply set sensible sizes for your tablespaces and monitor, unless the requirements are highly unusual. Received on Mon Dec 13 2010 - 18:35:06 CST