查询默认表空间的View：DATABASE_PROPERTIES

DATABASE_PROPERTIES
Lists permanent database properties. Use for 8i and older.

	Not NULL		Description
PROPERTY_NAME	NOT NULL	VARCHAR2(30)	Property name
PROPERTY_VALUE		VARCHAR2(4000)	Property value
DESCRIPTION		VARCHAR2(4000)	Property description

Related Parameters:
	Specifies whether a is required to have the same name as the database to which it connects.
	Specifies which calendar system Oracle uses.
	NLS comparison.
nls_currency	Specifies the string to use as the local currency symbol for the L number format element.
	Specifies the default to use with the and functions.
	Specifies the language to use for the spelling of day & month names and date abbreviations returned by and functions.
nls_dual_currency	Specifies the dual currency symbol (such as "Euro") for the territory.
nls_iso_currency	Specifies the string to use as the international currency symbol for the C number format element.
	Specifies the default language of the database.
	Enables creation of CHAR and VARCHAR2 columns using either byte or character length semantics.
	Determines whether data loss during an implicit or explicit character type conversion will report an error.
	Specifies the characters to use as the group separator and decimal character.
	Specifies the collating sequence for ORDER BY queries.
	Specifies the name of the whose conventions are to be followed for day and week numbering.
	Defines the default time format to use with the and functions.
	Defines tthe default time with time zone format to use with the and functions.
	Defines the default timestamp format to use with the and functions.
	Defines tthe default timestamp with time zone format to use with the and functions.

Related Commands:
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temporary_tablespace_name
ALTER DATABASE RENAME GLOBAL_NAME TO database_name[.domain]
ALTER DATABASE [NATIONAL] CHARACTER SET character_set

Related Views:
	NLS parameters of the database.
	NLS parameters of the instance.
	NLS parameters of the user session.
	Lists "hard" database settings.
	Contains current values of NLS parameters.
	Contains all possible valid NLS parameter settings.
	This view lists valid time zone names.
	Database fixed properties.

--lists permanent database properties
col property_name for a25
col property_value for a40
col description for a40
select * from  order by 1;

PROPERTY_NAME             PROPERTY_VALUE                           DESCRIPTION
------------------------- ---------------------------------------- ----------------------------------------
DBTIMEZONE                0:00                                     DB time zone
DEFAULT_TEMP_TABLESPACE   TEMP                                     ID of default temporary tablespace
DICT.BASE                 2                                        dictionary base tables version #
EXPORT_VIEWS_VERSION      8                                        Export views revision #
GLOBAL_DB_NAME            BANTEST                                  Global database name
NLS_CALENDAR              GREGORIAN                                Calendar system
NLS_CHARACTERSET          WE8ISO8859P1                             Character set
NLS_COMP                  BINARY                                   NLS comparison
NLS_CURRENCY              $                                        Local currency
NLS_DATE_FORMAT           DD-MON-RR                                Date format
NLS_DATE_LANGUAGE         AMERICAN                                 Date language
NLS_DUAL_CURRENCY         $                                        Dual currency symbol
NLS_ISO_CURRENCY          AMERICA                                  ISO currency
NLS_LANGUAGE              AMERICAN                                 Language
NLS_LENGTH_SEMANTICS      BYTE                                     NLS length semantics
NLS_NCHAR_CHARACTERSET    AL16UTF16                                NCHAR Character set
NLS_NCHAR_CONV_EXCP       FALSE                                    NLS conversion exception
NLS_NUMERIC_CHARACTERS    .,                                       Numeric characters
NLS_RDBMS_VERSION         9.2.0.4.0                                RDBMS version for NLS parameters
NLS_SAVED_NCHAR_CS        WE8ISO8859P1
NLS_SORT                  BINARY                                   Linguistic definition
NLS_TERRITORY             AMERICA                                  Territory
NLS_TIMESTAMP_FORMAT      DD-MON-RR HH.MI.SSXFF AM                 Time stamp format
NLS_TIMESTAMP_FORMAT      DD-MON-RR HH.MI.SSXFF AM                 Time stamp format
NLS_TIMESTAMP_TZ_FORMAT   DD-MON-RR HH.MI.SSXFF AM TZH:TZM         Timestamp with timezone format
NLS_TIMESTAMP_TZ_FORMAT   DD-MON-RR HH.MI.SSXFF AM TZH:TZM         Timestamp with timezone format
NLS_TIME_FORMAT           HH.MI.SSXFF AM                           Time format
NLS_TIME_FORMAT           HH.MI.SSXFF AM                           Time format
NLS_TIME_TZ_FORMAT        HH.MI.SSXFF AM TZH:TZM                   Time with timezone format
NLS_TIME_TZ_FORMAT        HH.MI.SSXFF AM TZH:TZM                   Time with timezone format