Moving & Recreate Temp Tablespace
I Recreate the temp tablespace coz my temp tablespace was corrupt,
you can do to the following bellow
- create temporary tablespace temp2 tempfile ‘/rdbms/temp01/temp2.dbf’ size 10M extent management local uniform size 1M;
- alter database default temporary tablespace temp2;
- drop tablespace temp including contents and datafiles;
now change back to temp again with following step bellow:
- create temporary tablespace temp tempfile ‘/rdbms/temp01/temp2_01.dbf’ size 1024M extent management local uniform size 1M;
- alter database default temporary tablespace temp;
- drop tablespace temp2 including contents and datafiles;
- alter tablespace temp add tempfile ‘/rdbms/temp01/temp2_02.dbf’ size 1024M;