Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)

Changing the Size of the Tablespace

You use the ALTER TABLESPACE command to alter the default storage definition of a tablespace or to add a data file to it. The following is the generic command to alter the storage settings for a tablespace:

ALTER TABLESPACE tablespacename
[MINIMUM EXTENT integer [K|M]
[DEFAULT storage clause]

Only dictionary managed tablespaces can have their storage settings altered.

Resizing a Tablespace

To resize a tablespace, you can either add a new data file to that tablespace, or you can change the size of an existing data file (either automatically or manually).

Adding a data file can be accomplished with the following ...