一个以前没注意到的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