Re: how to drop and re-create temporary tablespace group 11G)?

From: Roger Xu <wellmetus_at_gmail.com>
Date: Mon, 30 Nov 2009 09:10:16 -0600
Message-ID: <eb64345d0911300710k202d6d30j348ad275c16abeae_at_mail.gmail.com>

temp tablespace group was introduced in 10g. You may use this to take a temp tablepspace out of a group.

ALTER TABLESPACE temp TABLESPACE GROUP ``;

Also, DBA_TABLESPACE_GROUPS is where you can find all the temp tablespaces for a group.

On Mon, Nov 30, 2009 at 8:11 AM, dba1 mcc <mccdba1_at_yahoo.com> wrote:

> ORACLE 11G support temporary tablespace group. You can combine several
> temporary tablespace as one group.
>
> Does any one know how to drop it (include group and all temporary
> tablespaces) and recreate it?
>
> Thanks.
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 30 2009 - 09:10:16 CST