Symptom
You want to drop temporary tablespace from your Oracle database.
Solution
Oracle temporary tablespace cannot be deleted directly. You will need to create another temporary tablespace (dummy), assign as the default temporary tablespace and after that, you can directly drop the temporary tablespace.
Please refer to this article, Create, Add & Drop PSAPTEMP Tablespace. This example is done for Oracle database which used in SAP. The steps will be the same.
