explanation of the output columns. Used(MB) = Total space occupied by objects in the tablespace AW(MB) = How much space is consumed by analytic workspaces in the tablespace AW# = Count of analytic ...

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 ...