Taking a Tablespace Offline

You can use Oracle Enterprise Manager Database Express (EM Express) to take 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. In EM Express, from the Storage menu, select Tablespaces.

    The Tablespaces page appears.

  2. Select the tablespace that you want to take offline. From the Actions menu, select Set Status, then Take Offline.

    The Bring Tablespace Offline page appears.

  3. For Offline Options, select Normal.
  4. Click OK.

    A confirmation message appears.

Note:

To bring the tablespace back online, select the tablespace on the Tablespaces page. Then from the Actions menu, select Set Status, then Place Online.

See Also:

Oracle Database Administrator's Guide for more information about taking tablespaces offline and for information about renaming or relocating data files.