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

  • From: Roger Xu <wellmetus@xxxxxxxxx>
  • To: mccdba1@xxxxxxxxx
  • Date: Mon, 30 Nov 2009 09:10:16 -0600

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@xxxxxxxxx> 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.
>
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>

Other related posts: