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

  1. c r e a t e temporary tablespace temp2 tempfile ‘/rdbms/temp01/temp2.dbf’ size 10M extent mangement local uniform size 1M;
  2. alter d a t a b a s e default temporary tablespace temp2;
  3. d r o p tablespace temp including contents and datafiles;

now change back to temp again with following step bellow:

  1. c r e a t e temporary tablespace temp tempfile ‘/rdbms/temp01/temp2_01.dbd’ size 1000M extent management local uniform size 1M;
  2. a l t e r database default temporary tablespace temp;
  3. d r o p tablespace temp2 including contens and datafiles;
  4. a l t e r tablespace temp add tempfile ‘/rdbms/temp01/temp2_02.dbf’ size 1000M;

Popularity: 26% [?]

You Should Also Check Out This Post:

More Active Posts: