Sys-Admin Information's

I Recreate the temp tablespace coz my temp tablespace was corrupt,
you can do to the following bellow

1. create temporary tablespace temp2 tempfile '/rdbms/temp01/temp2.dbf' size 10M extent management local uniform size 1M;
2. alter database default temporary tablespace temp2;
3. drop tablespace temp including contents and datafiles;

now change back to temp again with following step bellow:

1. create temporary tablespace temp tempfile '/rdbms/temp01/temp2_01.dbf' size 1024M extent management local uniform size 1M;
2. alter database default temporary tablespace temp;
3. drop tablespace temp2 including contents and datafiles;
4. alter tablespace temp add tempfile '/rdbms/temp01/temp2_02.dbf' size 1024M;