Temp Tablespace maintenance

HOW TO RESIZE TEMPORARY TABLESPACE IN ORACLE

Issue :

While creating subtask in project .net it shows the following error message.

" Unexpected cycle in dependency cycle. No data has been saved. "

Then I view page source of that html file. It shows

Caused by: java.sql.SQLException: ORA-25153: Temporary Tablespace is Empty

ORA-06512: at "PNET.SCHEDULE", line 1444

ORA-06512: at line 1

The issue is  temp file full.

Solution :

SQL > select * from database_properties where property_name like '%TABLESPACE';

SQL > alter database default temporary tablespace temp;

SQL > select username,temporary_tablespace,account_status from dba_users;

SQL > alter tablespace temp add tempfile '/Project.net/xe/oradata/XE/temp.dbf' reuse;

Ref :

http://www.dba-oracle.com/t_ora_25153_temporary_tablespace_is_empty.htm

http://www.mydigitallife.info/ora-25153-temporary-tablespace-is-empty-error-in-oracle/