dbf, specify that each extension of the datafile is 20MB, and specify that the total
size of the datafile cannot exceed 1GB:
SQL> alter database
2 datafile '/u01/app/oracle/oradata/rmanrep/users01.dbf'
3 autoextend on
4 next 20m
5 maxsize 1g;
Database altered.
78 Oracle Database 11g DBA Handbook
If the disk volume containing the datafile does not have the disk space available for the
expansion of the datafile, we must either move the datafile to another disk volume or create a
second datafile for the tablespace on another disk volume. In this example, we??™re going to add a
second datafile to the USERS tablespace on a different disk volume with an initial size of 50MB,
allowing for the automatic extension of the datafile, with each extension 10MB and a maximum
datafile size of 200MB:
SQL> alter tablespace users
2 add datafile '/u03/oradata/users02.dbf'
3 size 50m
4 autoextend on
5 next 10m
6 maxsize 200m;
Tablespace altered.
Notice that when we modify an existing datafile in a tablespace, we use the alter database
command, whereas when we add a datafile to a tablespace, we use the alter tablespace command.
As you will see shortly, using a bigfile tablespace simplifies these types of operations.
Resizing a Smallfile Tablespace Using EM Database Control
Using EM Database Control, we can use either of the methods described in the preceding section:
increase the size and turn on autoextend for the tablespace??™s single datafile, or add a second datafile.
Pages:
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179