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 > > >