OCM_Session1_5_TablespaceCreationandConfigurationnote - 数据库编程

----------------------------- -------------------------------------------------- -------------------------------------------------- NLS_CALENDAR GREGORIAN Calendar system NLS_DATE_FORMAT DD-MON-RR Date format NLS_DATE_LANGUAGE AMERICAN Date language NLS_SORT BINARY Linguistic definition NLS_TIME_FORMAT HH.MI.SSXFF AM Time format NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM Time stamp format NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR Time with timezone format NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR Timestamp with timezone format NLS_DUAL_CURRENCY $ Dual currency symbol NLS_COMP BINARY NLS comparison NLS_LENGTH_SEMANTICS BYTE NLS length semantics
PROPERTY_NAME PROPERTY_VALUE DESCRIPTION ------------------------------ -------------------------------------------------- -------------------------------------------------- NLS_NCHAR_CONV_EXCP FALSE NLS conversion exception NLS_NCHAR_CHARACTERSET AL16UTF16 NCHAR Character set NLS_RDBMS_VERSION 10.2.0.1.0 RDBMS version for NLS parameters GLOBAL_DB_NAME PROD Global database name EXPORT_VIEWS_VERSION 8 Export views revision #
27 rows selected.
SQL> select name from v$tablespace;
NAME ------------------------------ SYSTEM UNDOTBS1 SYSAUX TEMPTS1

SQL> create temporary tablespace temp1 tempfile '/u01/app/oracle/oradata/PROD/Disk1/temp11.dbf' size 20m 2 tablespace group temp_grp;
Tablespace created.
SQL> create temporary tablespace temp2 tempfile '/u01/app/oracle/oradata/PROD/Disk1/temp12.dbf' size 20m 2 tablespace group temp_grp;
Tablespace created.

SQL> alter database default temporary tablespace temp_grp;
Database altered.
SQL> select name from v$tablespace;
NAME ------------------------------ SYSTEM UNDOTBS1 SYSAUX TEMPTS1 TEMP1 TEMP2
6 rows selected.
SQL> select * from DATABASE_PROPERTIES;
PROPERTY_NAME PROPERTY_VALUE DESCRIPTION ------------------------------ -------------------------------------------------- -------------------------------------------------- DICT.BASE 2 dictionary base tables version # DEFAULT_TEMP_TABLESPACE TEMP_GRP Name of default temporary tablespace DEFAULT_PERMANENT_TABLESPACE SYSTEM Name of default permanent tablespace DBTIMEZONE +08:00 DB time zone DEFAULT_TBS_TYPE SMALLFILE Default tablespace type NLS_LANGUAGE AMERICAN Language NLS_TERRITORY AMERICA Territory NLS_CURRENCY $ Local currency NLS_ISO_CURRENCY AMERICA ISO currency NLS_NUMERIC_CHARACTERS ., Numeric characters NLS_CHARACTERSET AL32UTF8 Character set
PROPERTY_NAME PROPERTY_VALUE DESCRIPTION ------------------------------ -------------------------------------------------- -------------------------------------------------- NLS_CALENDAR GREGORIAN Calendar system NLS_DATE_FORMAT DD-MON-RR Date format NLS_DATE_LANGUAGE AMERICAN Date language NLS_SORT BINARY Linguistic definition NLS_TIME_FORMAT HH.MI.SSXFF AM Time format NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM Time stamp format NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR Time with timezone format NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR Timestamp with timezone format NLS_DUAL_CURRENCY $ Dual currency symbol NLS_COMP BINARY NLS comparison NLS_LENGTH_SEMANTICS BYTE NLS length semantics
PROPERTY_NAME PROPERTY_VALUE DESCRIPTION ------------------------------ -------------------------------------------------- ------------------

OCM_Session1_5_TablespaceCreationandConfigurationnote(二)