ORA-25153: Temporary Tablespace is Empty

ORA-25153: Temporary Tablespace is Empty:

To add the temp tablespace on oracle11g :

alter tablespace  TEMP add TEMPFILE 'E:\oradata\xyz\TEMP01.dbf' size 100M reuse autoextend on next 5M maxsize 500M;

To add tha pstemp tablespace on oracle11g:

alter tablespace PSTEMP add TEMPFILE 'E:\oradata\xyz\PSTEMP01.dbf' size 50M reuse autoextend on next 5M maxsize 500M;

To drop the tablespace:

ALTER DATABASE TEMPFILE 'E:\oradata\xyz90\TEMP01.dbf' DROP INCLUDING DATAFILES;

For creation of tablespace:

CREATE TABLESPACE lmtbsb DATAFILE '/u02/oracle/data/lmtts01.dbf' SIZE 50M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

The following query is for creating an encrypted tablespace with some default encryption algorithm:

CREATE TABLESPACE securespace DATAFILE '/u01/app/oracle/oradata/orcl/secure01.dbf' SIZE 100M ENCRYPTION DEFAULT STORAGE(ENCRYPT);