Re: Maxsize for Set of Tablespaces in 10g and 11i?
From: joel garry <joel-garry_at_home.com>
Date: Mon, 13 Dec 2010 10:26:58 -0800 (PST)
Message-ID: <9d431b48-d32b-4d18-8be9-374cfaf15bf2_at_h17g2000pre.googlegroups.com>
On Dec 13, 7:40 am, "if_inves..._at_yahoo.com" <basis_consult..._at_hotmail.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.
>
> Thanks
Date: Mon, 13 Dec 2010 10:26:58 -0800 (PST)
Message-ID: <9d431b48-d32b-4d18-8be9-374cfaf15bf2_at_h17g2000pre.googlegroups.com>
On Dec 13, 7:40 am, "if_inves..._at_yahoo.com" <basis_consult..._at_hotmail.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.
>
> Thanks
I don't think so, but I can see where that would be useful. One way or another, you are going to have to monitor it.
jg
-- _at_home.com is bogus. http://www.computerworlduk.com/news/it-business/3253246/oracle-wants-apache-to-return-to-java-governing-body/?olo=rssReceived on Mon Dec 13 2010 - 12:26:58 CST