检查默认永久表空间、临时表空间与UNDO表空间的设置
本文仅做记录，目标如题所示。
具体如下：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 |
SQL> set linesize 500 SQL> col description for a40 SQL> col property_value for a15 SQL> SQL> select * from database_properties where property_name='DEFAULT_PERMANENT_TABLESPACE'; PROPERTY_NAME PROPERTY_VALUE DESCRIPTION ------------------------------ --------------- ---------------------------------------- DEFAULT_PERMANENT_TABLESPACE USERS Name of default permanent tablespace 1 row selected. SQL> SQL> SQL> select * from database_properties where property_name='DEFAULT_TEMP_TABLESPACE'; PROPERTY_NAME PROPERTY_VALUE DESCRIPTION ------------------------------ --------------- ---------------------------------------- DEFAULT_TEMP_TABLESPACE TEMP Name of default temporary tablespace 1 row selected. SQL> SQL> set linesize 400 SQL> col name for a25 SQL> col value for a15 SQL> SQL> select name,value from v$parameter where name in ('undo_management','undo_tablespace'); NAME VALUE ------------------------- --------------- undo_management AUTO undo_tablespace UNDOTBS 2 rows selected. SQL> |
如果需要修改：
|
1 2 |
alter database default tablespace users; alter database default temporary tablespace temp; |
——————————————————
Done。
