Oracle / PLSQLDROP TABLESPACE statement.

DROP TABLESPACE. Purpose. Use the DROP TABLESPACE statement to remove a tablespace from the database. When you drop a tablespace, Oracle Database does not place it in the recycle bin. Therefore, you cannot subsequently either purge or undrop the tablespace. For example, if a table in the tablespace is currently being used or the tablespace contains undo data needed to roll back uncommitted transactions, you cannot drop the tablespace. The tablespace can be online or offline, but it is best to take the tablespace offline before dropping it. To drop a tablespace, use the DROP TABLESPACE statement.

This Oracle tutorial explains how to use the Oracle DROP TABLESPACE statement with syntax and examples. The DROP TABLESPACE statement is used to remove a tablespace from the Oracle. Summary: in this tutorial, you will learn how to remove a tablespace from the database by using the Oracle DROP TABLESPACE statement. Introduction to Oracle DROP TABLESPACE statement. The DROP TABLESPACE allows you to remove a tablespace from the database. Here is the basic syntax of the DROP TABLESPACE statement.