H
Chapter 3: Planning and Managing Tablespaces 63
SYSTEM Tablespace User segments should never reside in the SYSTEM tablespace, period. As of
Oracle 10g, you can specify a default permanent tablespace in addition to the ability to specify a
default temporary tablespace in Oracle9i.
If you use the Oracle Universal Installer (OUI) to create a database for you, a separate
tablespace other than SYSTEM is created for both permanent and temporary segments. If you
create a database manually, be sure to specify both a default permanent tablespace and a default
temporary tablespace, as in the sample create database command that follows.
CREATE DATABASE rjbdb
USER SYS IDENTIFIED BY kshelt25
USER SYSTEM IDENTIFIED BY mgrab45
LOGFILE GROUP 1 ('/u02/oracle11g/oradata/rjbdb/redo01.log') SIZE 100M,
GROUP 2 ('/u04/oracle11g/oradata/rjbdb/redo02.log') SIZE 100M,
GROUP 3 ('/u06/oracle11g/oradata/rjbdb/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/u01/oracle11g/oradata/rjbdb/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/oracle11g/oradata/rjbdb/sysaux01.dbf'
SIZE 325M REUSE
DEFAULT TABLESPACE USERS
DATAFILE '/u03/oracle11g/oradata/rjbdb/users01.dbf'
SIZE 50M REUSE
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/oracle11g/oradata/rjbdb/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/u02/oracle11g/oradata/rjbdb/undotbs01.
Pages:
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160