OCM_Session1_5_TablespaceCreationandConfigurationnote - 数据库编程

---------------------------- -------------------------------------------------- -------------------------------------------------- DICT.BASE 2 dictionary base tables version # DEFAULT_TEMP_TABLESPACE TEMP_GRP Name of default temporary tablespace DEFAULT_PERMANENT_TABLESPACE USERS Name of default permanent tablespace DBTIMEZONE +08:00 ...

5.6 Create a permanent tablespace for storing segments associated with online transaction processing with high insert rates. Due to the potential high volume of concurrent inserts, every effort should be taken to reduce contention for each of the tables that will be stored in this tablespace. Use the following specifications: 5.6.1 Tablespace name of OLTP 5.6.2 File size of 48MB 5.6.3 Initial extent size of 2MB 5.6.4 Next extent size of 2MB
(ASSM)

操作如下：
SQL> create tablespace oltp datafile '/u01/app/oracle/oradata/PROD/Disk1/oltp01.dbf' size 48m 2 extent management local uniform size 2m segment space management auto;
Tablespace created.

OCM_Session1_5_TablespaceCreationandConfigurationnote(三)