Re: Maxsize for Set of Tablespaces in 10g and 11i?
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Mon, 13 Dec 2010 10:27:16 -0800 (PST)
Message-ID: <e399694f-82e9-4b23-bff9-1916fb84df53_at_n32g2000pre.googlegroups.com>
On Dec 13, 10: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:27:16 -0800 (PST)
Message-ID: <e399694f-82e9-4b23-bff9-1916fb84df53_at_n32g2000pre.googlegroups.com>
On Dec 13, 10: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
The size of Oracle tablespace is determine by the Oracle block size, type of tablespace, and in the case of small file tablesaces number of files with up to approx. 4 million blocks per file.
You can find the specificies in the Oracle version# Reference manual.
For 11gR2
http://download.oracle.com/docs/cd/E11882_01/server.112/e17110/limits002.htm#i287915
HTH -- Mark D Powell -- Received on Mon Dec 13 2010 - 12:27:16 CST