一个以前没注意到的VIEW 可以查database的DEFAULT属性
SQL> desc database_properties;
名称 是否为空? 类型
----------------------------------------- -------- ----------------------------
PROPERTY_NAME NOT NULL VARCHAR2(30)
PROPERTY_VALUE VARCHAR2(4000)
DESCRIPTION VARCHAR2(4000)
PROPERTY_NAME
------------------------------
DICT.BASE
DEFAULT_TEMP_TABLESPACE
DEFAULT_PERMANENT_TABLESPACE
DEFAULT_TBS_TYPE
NLS_LANGUAGE
NLS_TERRITORY
NLS_CURRENCY
NLS_ISO_CURRENCY
NLS_NUMERIC_CHARACTERS
NLS_CHARACTERSET
NLS_CALENDAR
PROPERTY_NAME
------------------------------
NLS_DATE_FORMAT
NLS_DATE_LANGUAGE
NLS_SORT
NLS_TIME_FORMAT
NLS_TIMESTAMP_FORMAT
NLS_TIME_TZ_FORMAT
NLS_TIMESTAMP_TZ_FORMAT
NLS_DUAL_CURRENCY
NLS_COMP
NLS_LENGTH_SEMANTICS
NLS_NCHAR_CONV_EXCP
PROPERTY_NAME
------------------------------
NLS_NCHAR_CHARACTERSET
NLS_RDBMS_VERSION
GLOBAL_DB_NAME
EXPORT_VIEWS_VERSION
DBTIMEZONE
已选择27行。
SQL> col property_value format a30
SQL> col description format a30
SQL> select property_value,description from database_properties where PROPERTY_NA
ME ='DEFAULT_TBS_TYPE';
PROPERTY_VALUE DESCRIPTION
------------------------------ ------------------------------
SMALLFILE Default tablespace type********************
SQL> select property_name from database_properties;
默认 ORACLE 都建立小文件 TABLESPACE
可以通过
alter database set default bigfile
smallfile tablespace 来改变
改用户default tablespace
default temporary tablespace
alter database set default tablespace XX
default tablespace SET default temporary tablespace xxX