Cause
The tablespace was used for a composite sharded table and cannot be dropped unless the contents are dropped manually.
Action
Drop the contents of the tablespace set first and then drop the tablespace set.
Oracle 26ai
ORA-03923
Error Message
cannot drop a tablespace set used for a composite sharded table