Taking a Tablespace Offline

You may want to take a tablespace offline for any of the following reasons:

• To make a portion of the database unavailable while still allowing access to the remainder of the database

• To make an application and its group of tables temporarily unavailable while updating or maintaining the application

• To perform an offline tablespace backup (even though a tablespace can be backed up while online and in use)

• To recover a tablespace after a hardware or software failure

• To rename or relocate tablespace data files

To take a tablespace offline:

1. Go to the Database Home page.

   See "Accessing the Database Home Page".

2. At the top of the page, click Server to view the Server subpage.

3. In the Storage section, click Tablespaces.

   The Tablespaces page appears.

4. Select the tablespace to take offline, and then click Edit.

   The Edit Tablespace page appears.

5. In the Status section, select Offline.

   For more information about the selections on this page, click Help.

6. Make a selection from the Offline Mode list, and then click Apply.

   A confirmation message appears.