This SQL statement is valid only if you are using Oracle Sharding. For more information on Oracle Sharding, refer to Oracle Database Administrator’s Guide.
SET statement to drop a tablespace set from a shardgroup.
When you drop a tablespace set, Oracle Database does not place it in the recycle bin. Therefore, you cannot subsequently either purge or undrop the tablespace set.
You must be connected to a shard catalog database as an SDB user.
You must have the
TABLESPACE system privilege. You cannot drop a tablespace set if its tablespaces contain any rollback segments holding active transactions.
Specify the name of the tablespace set to be dropped.
This clause lets you specify how the database manages objects and datafiles associated with the tablespaces in the tablespace set during the drop operation. The
CONTENTS clause has the same semantics here as for the
TABLESPACE statement. See INCLUDING CONTENTS for the full semantics of this clause.
Dropping a Tablespace Set: Example
The following statement drops the tablespace set
DROP TABLESPACE SET ts1;