A couple of changes have been made to the data dictionary views in Oracle Database 10g
and Oracle Database 11g to support temporary tablespace groups. The data dictionary view
DBA_USERS still has the column TEMPORARY_TABLESPACE, as in previous versions of Oracle,
but this column may now contain either the name of the temporary tablespace assigned to the
user, or the name of a temporary tablespace group.
SQL> select username, default_tablespace, temporary_tablespace
2 from dba_users where username = 'JENWEB';
USERNAME DEFAULT_TABLESPACE TEMPORARY_TABLESPACE
-------------------- ------------------ --------------------
JENWEB USERS TEMPGRP
1 row selected.
Chapter 3: Planning and Managing Tablespaces 67
The new data dictionary view DBA_TABLESPACE_GROUPS shows the members of each
temporary tablespace group:
SQL> select group_name, tablespace_name from dba_tablespace_groups;
GROUP_NAME TABLESPACE_NAME
---------------------------- ----------------------------
TEMPGRP TEMP1
TEMPGRP TEMP2
TEMPGRP TEMP3
3 rows selected.
As with most every other feature of Oracle that can be accomplished with the command
line, assigning members to temporary tablespace groups or removing members from temporary
tablespace groups can be performed using EM Database Control. In Figure 3-4, we can add or
remove members from a temporary tablespace group.
Bigfile
A bigfile tablespace eases database administration because it consists of only one datafile.
Pages:
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165