Quote Originally Posted by shrikant.patil
Hi All,

can somebody help ..
how to reduce fragementation of temporary tablespace ..
bcause always my temp tableapace gets full ...
It always helps to start by posting in the right forum.

The first question is how do you know you have fragmentation? Secondly, Oracle does not necessarily free space in the temp tablespace. Don't expect TEMP to shrink even if its not in use.