Case

During dropping psaptemp you get ORA-12906 error

Solution

First create another temporary tablespace for example temp2

SQL> CREATE TEMPORARY TABLESPACE temp2

TEMPFILE ‘/oracle/SM5/sapdata3/temp_2/temp2.data1’ SIZE 50M REUSE AUTOEXTEND ON ;

SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2;

Drop old psaptemp

SQL> DROP TABLESPACE PSAPTEMP INCLUDING CONTENTS AND DATAFILES;