Re: mystery object
Date: Thu, 26 Feb 2009 08:12:47 +0200
It is appearing in the data tablespace because when you do: alter index rebuild online (for example) oracle assign temp segments in the data tablespace and rename them after completion. I used this example because oracle can not create normal segments as there is already an object (index) with that name.
M Rafiq wrote:
> Please also check why data tablespace is being used instead of temp
> Hope this help.