Managing Tablespaces : Altering Tablespace Availability

You can take an online tablespace offline so that it is temporarily unavailable for
general use. The rest of the database remains open and available for users to
access data. Conversely, you can bring an offline tablespace online to make the
schema objects within the tablespace available to database users.

The database must be open to alter the availability of a tablespace.

To alter the availability of a tablespace, use the ALTER TABLESPACE statement.

You must have the ALTER TABLESPACE or MANAGE TABLESPACE system privilege.