Re: how to drop and re-create temporary tablespace group 11G)?
- From: Kellyn Pedersen <kjped1313@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx, mccdba1@xxxxxxxxx
- Date: Mon, 30 Nov 2009 11:07:20 -0800 (PST)
As far as I know, you can not drop a temp tablespace group as a whole, (my fear
is that in 11g you can and I'm still back in 10g world!)
What you can do is select from dba_tablespace_groups and after you have
verified that there are no users POINTED to that ol' temp tablespace group, you
can drop each of the temp tablespaces individually.
SQL> select * from dba_tablespace_groups;
GROUP_NAME TABLESPACE_NAME
------------------------------ ------------------------------
SAMP_TEMP TEMP_SAMP1
SAMP_TEMP TEMP_SAMP2
SAMP_TEMP TEMP_SAMP3
SAMP_TEMP TEMP_SAMP4
SAMP_TEMP TEMP_SAMP5
SAMP_TEMP TEMP_SAMP6
6 rows selected.
SQL> drop tablespace temp_samp6;
Tablespace dropped.
so on and so forth...
If anyone has experience with these in 11g, please chime in and correct me with
updated info! :)
Kellyn Pedersen
Multi-Platform DBA
I-Behavior Inc.
http://www.linkedin.com/in/kellynpedersen
"Go away before I replace you with a very small and efficient shell script..."
--- On Mon, 11/30/09, dba1 mcc <mccdba1@xxxxxxxxx> wrote:
From: dba1 mcc <mccdba1@xxxxxxxxx>
Subject: how to drop and re-create temporary tablespace group 11G)?
To: oracle-l@xxxxxxxxxxxxx
Date: Monday, November 30, 2009, 7:11 AM
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:
