<div>
I believe there is a known bug with 9i and possibly 10g about this issue.<br />
<br />
You can try creating a new temp tablespace and setting the database default temporary tablespace to temp2, dropping the old one. Then you can just leave it with temp2 or you can re-create an even larger one and revert back.<br />
<br />
<br />
SQL&gt; create temporary tablespace temp2 tempfile 'c:\oracle\dev\temp02.dbf'<wbr /> size 1024m;<br />
<br />
Tablespace created.<br />
<br />
SQL&gt; alter database default temporary tablespace temp2;<br />
<br />
Database altered.<br />
<br />
SQL&gt; drop tablespace temp including contents and datafiles;<br />
<br />
Tablespace dropped.<br />
<br />
<br />

</div>


I believe there is a known bug with 9i and possibly 10g about this issue.

You can try creating a new temp tablespace and setting the database default temporary tablespace to temp2, dropping the old one. Then you can just leave it with temp2 or you can re-create an even larger one and revert back.


SQL> create temporary tablespace temp2 tempfile 'c:\oracle\dev\temp02.dbf' size 1024m;

Tablespace created.

SQL> alter database default temporary tablespace temp2;

Database altered.

SQL> drop tablespace temp including contents and datafiles;

Tablespace dropped.




<div>
<div class="content wysiwyg-content">
My Oracle temp tablespace is 100% utilized.<br />
I am trying to Flush it out by re-starting the database but still after the re-start it shows 100% utilized.<br />
<br />
Can any one tell me what might be the reason.<br />
<br />
As far as i know Oracle(i m using 10g) frees temp tablespace automatically .<br />
<br />
Now i have an option to re-create the TEMp tbs AND fix this issue but i would like to know why issue is not getting<br />
fixed after restart
</div>
</div>


My Oracle temp tablespace is 100% utilized.
I am trying to Flush it out by re-starting the database but still after the re-start it shows 100% utilized.

Can any one tell me what might be the reason.

As far as i know Oracle(i m using 10g) frees temp tablespace automatically .

Now i have an option to re-create the TEMp tbs AND fix this issue but i would like to know why issue is not getting
fixed after restart

oracle TEMP TBS

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.