数据库默认临时表空间
要删除一temp表空间，报 ORA-12906，
SQL> drop tablespace temp；
ERROR at line 1:
ORA-12906: cannot drop default temporary tablespace
一查，原来是Default temporary tablespace在搞怪
SQL> select * from database_properties ;
PROPERTY_NAME PROPERTY_VALUE DESCRIPTION
————————— ————————– —————————
DEFAULT_TEMP_TABLESPACE TEMP ID of default temporary tablespace
SQL> alter database default temporary tablespace temp01;
Database altered.
SQL> drop tablespace temp;
Tablespace dropped.
11g都要出来了，9i还没有用太多 噻
.text:''):(d.getSelection?d.getSelection():'');void(keyit=window.open('http://my.poco.cn/fav/storeIt.php?t='+escape(d.title)+'&u='+escape(d.location.href)+'&c='+escape(t)+'&img=http://www.h-strong.com/blog/logo.gif','keyit','scrollbars=no,width=475,height=575,status=no,resizable=yes'));keyit.focus(); "添加到 POCO 网摘"){kind=logo}
well