By clicking the Edit button, you can see the characteristics of the XPORT tablespace, as
shown in Figure 4-2. It is locally managed, permanent, and not a bigfile tablespace (i.e., it is a
smallfile tablespace). At the bottom of the page is the single datafile for the XPORT tablespace, /
u02/oradata/xport.dbf.
FIGURE 4-1 Using EM Database Control to edit tablespace characteristics
80 Oracle Database 11g DBA Handbook
With the only datafile in the XPORT tablespace selected, click the Edit button or click the
datafile name itself, and you will see the Edit Tablespace: Edit Datafile page, shown in Figure 4-3,
where you can change the size of the datafile. On this page, change the file size from 150MB to
200MB and click Continue.
In Figure 4-4, you are back to the Edit Tablespace page. At this point, you can make the changes
to the datafile by clicking Apply, cancel the changes by clicking Revert, or show the SQL to be
executed by clicking Show SQL.
Before committing the changes, it is often beneficial to review the SQL commands about to
be executed by clicking the Show SQL button??”it is a good way to brush up on your SQL command
syntax! Here is the command that will be executed when you click Apply:
ALTER DATABASE DATAFILE '/u02/oradata/xport.dbf' RESIZE 200M
When you click Apply, Oracle changes the size of the datafile. The Edit Tablespace: XPORT
page reflects the successful operation and the new size of the datafile, as you can see in Figure 4-5.
Pages:
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181