Steps to recreate TEMP Table-space or TEMP Space is Full.

Step to re-create TEMP table-space.

1.Create a new TEMP table-space name TEMP2.

SQL> CREATE TEMPORARY TABLESPACE TEMP2 TEMPFILE  ‘/oradata/TAREPOS/TAREPOS/temp2_01.dbf’ SIZE 1024M AUTOEXTEND OFF EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

Tablespace created.

SQL>

2. Set new table-space TEMP2 as DEFAULT table-space.

SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2;

Database altered.

SQL>

3. Drop table-space TEMP and all its content & data-files.

SQL> DROP TABLESPACE temp INCLUDING CONTENTS AND DATAFILES;

Tablespace dropped.

SQL>

4. Re-create TEMP table-space.

SQL> CREATE TEMPORARY TABLESPACE TEMP TEMPFILE ‘/oradata/TAREPOS/TAREPOS/temp01.dbf’ SIZE 4096M AUTOEXTEND OFF EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

Tablespace created.

SQL>

5. Set new table-space TEMP as DEFAULT table-space.

SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp;

Database altered.

SQL>

6. Drop table-space TEMP2 and all its content & data-files.

SQL> DROP TABLESPACE temp2 INCLUDING CONTENTS AND DATAFILES;

Tablespace dropped.

SQL>

Note:- After completing all the above steps bounce the database once and check the issue.