Dropping a Tablespace

After a tablespace has been dropped (deleted), 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. 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 drop, and then click Delete.

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

5. Click Yes to remove the tablespace.

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