Resizing a Datafile in a Smallfile Tablespace To resize a datafile in EM Database Control, click
the Server tab from the database instance home page, then click Tablespaces under the Storage
Clause Description
autoextend When this clause is set to ON, the datafile will be allowed to expand.
When it??™s set to OFF, no expansion is allowed, and the other clauses are
set to zero.
next
The size, in bytes, of the next amount of disk space to allocate for the
datafile when expansion is required; the value can be qualified
with K, M, G, or T to specify the size in kilobytes, megabytes, gigabytes,
or terabytes, respectively.
maxsize When this clause is set to unlimited, the size of the datafile is unlimited
within Oracle, up to 128TB for a bigfile tablespace, and 128GB for a
smallfile tablespace with 32K blocks (otherwise limited by the file system
containing the datafile). Otherwise, maxsize is set to the maximum
number of bytes in the datafile, using the same qualifiers used in the next
clause: K, M, G, or T.
TABLE 4-1 Datafile Extension Clauses
Chapter 4: Physical Database Layouts and Storage Management 79
heading. In Figure 4-1, you have selected the XPORT tablespace; it is over 85 percent full, so you
decide to expand its size using a second datafile. This tablespace was originally created using this
command:
create tablespace xport datafile '/u02/oradata/xport.dbf' size 150m;
Rather than let the tablespace??™s datafile autoextend, we will change the current size of the
datafile to 200MB from 150MB.
Pages:
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180