SQL> CREATE TEMPORARY TABLESPACE LOGTMP
2 TEMPFILE 'C:\APP\ORADATA\MCOR\PDBORCL\LOGTMP.dbf' SIZE 5M
3 AUTOEXTEND ON NEXT 1M;
Tablespace created.
SQL> commit;
Commit complete.
SQL> ALTER PLUGGABLE DATABASE DEFAULT TEMPORARY TABLESPACE LOGTMP;
Pluggable database altered.
SQL> ALTER PLUGGABLE DATABASE DEFAULT TABLESPACE LOGTMP;
ALTER PLUGGABLE DATABASE DEFAULT TABLESPACE LOGTMP
*
ERROR at line 1:
ORA-12918: Invalid tablespace type for default permanent tablespace
SQL> DROP TABLESPACE LOGTMP INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE LOGTMP INCLUDING CONTENTS AND DATAFILES
*
ERROR at line 1:
ORA-12906: cannot drop default temporary tablespace