FIGURE 4-2 Tablespace characteristics
Chapter 4: Physical Database Layouts and Storage Management 81
FIGURE 4-3 Editing a tablespace??™s datafile
FIGURE 4-4 Confirming datafile changes
82 Oracle Database 11g DBA Handbook
Adding a Datafile to a Smallfile Tablespace Adding a datafile to a smallfile tablespace is just as
easy as resizing a datafile using EM Database Control. In our preceding example, we expanded
the datafile for the XPORT tablespace to 200MB. Because the file system (/u02) containing the
datafile for the XPORT tablespace is now at capacity, you will have to turn off AUTOEXTEND on
the existing datafile and then create a new datafile on a different file system. In Figure 4-6, you
turn off AUTOEXTEND for the existing datafile by unchecking the check box in the Storage
section. Here is the SQL command that is executed for this operation when you click Continue
and then Apply:
ALTER DATABASE
DATAFILE '/u02/oradata/xport.dbf'
AUTOEXTEND OFF;
On the Tablespaces page in earlier Figure 4-1, select the radio button next to the XPORT
tablespace, and click on the Edit button. You will see the page in Figure 4-7.
Click the Add button in Figure 4-7 and you will see the page in Figure 4-8.
FIGURE 4-5 Datafile resizing results
Chapter 4: Physical Database Layouts and Storage Management 83
FIGURE 4-6 Editing a tablespace??™s datafile characteristics
FIGURE 4-7 Editing the XPORT tablespace
84 Oracle Database 11g DBA Handbook
On the page in Figure 4-8, specify the filename and directory location for the new datafile.
Pages:
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182