Dropping a Tablespace

You can use Oracle Enterprise Manager Database Express (EM Express) to drop (delete) a tablespace. After a tablespace has been dropped, the objects and data in it are no longer available. To recover them can be a time-consuming process. Oracle recommends performing a backup before and after dropping a tablespace.

To drop a tablespace:

  1. In EM Express, from the Storage menu, select Tablespaces.

    The Tablespaces page appears.

  2. Select the tablespace to drop, and then click Drop.

    The Drop Tablespace page appears.

    EM Express asks for confirmation to delete the tablespace and gives you the option to also delete the associated data files from the disk.

  3. Choose from the following options and then click OK:

    • Drop Contents

    • Drop Datafiles

    • Drop Constraints

  4. A confirmation is displayed and the deleted tablespace no longer appears on the Tablespaces page.

See Also:

"About Tablespaces"