如何查看数据库默认临时表空间

2025年05月05日 20:56

有1个网友回答

网友（1）：

视图查询数据库默认临时表空间

DATABASE_PROPERTIES

示例：

SQL> set linesize 100;

SQL> set pagesize 50;

SQL> column PROPERTY_NAME format a30;

SQL> column PROPERTY_VALUE format a50;

SQL> select PROPERTY_NAME,PROPERTY_VALUE from

database_properties;

PROPERTY_NAME PROPERTY_VALUE

------------------------------ --------------------------------------------------

DICT.BASE 2

DEFAULT_TEMP_TABLESPACE TEMP

DEFAULT_PERMANENT_TABLESPACE USERS

DEFAULT_EDITION ORA$BASE

Flashback Timestamp TimeZone GMT

TDE_MASTER_KEY_ID

DBTIMEZONE +08:00

DST_UPGRADE_STATE NONE

DST_PRIMARY_TT_VERSION 14

DST_SECONDARY_TT_VERSION 0

DEFAULT_TBS_TYPE SMALLFILE

NLS_LANGUAGE AMERICAN

NLS_TERRITORY AMERICA

NLS_CURRENCY $

NLS_ISO_CURRENCY AMERICA

NLS_NUMERIC_CHARACTERS .,

NLS_CHARACTERSET AL32UTF8

NLS_CALENDAR GREGORIAN

NLS_DATE_FORMAT DD-MON-RR

NLS_DATE_LANGUAGE AMERICAN

NLS_SORT BINARY

NLS_TIME_FORMAT HH.MI.SSXFF AM

NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM

NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR

NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR

NLS_DUAL_CURRENCY $

NLS_COMP BINARY

NLS_LENGTH_SEMANTICS BYTE

NLS_NCHAR_CONV_EXCP FALSE

NLS_NCHAR_CHARACTERSET AL16UTF16

NLS_RDBMS_VERSION 11.2.0.4.0

GLOBAL_DB_NAME CSDB

EXPORT_VIEWS_VERSION 8

WORKLOAD_CAPTURE_MODE

WORKLOAD_REPLAY_MODE

NO_USERID_VERIFIER_SALT 30032902395C816F613E979347E4812C