Re: mystery object

From: Yechiel Adar <>
Date: Thu, 26 Feb 2009 08:12:47 +0200
Message-id: <>

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.

Adar Yechiel
Rechovot, Israel

M Rafiq wrote:
> Please also check why data tablespace is being used instead of temp
> tablespace.
> Hope this help.
> Regards
> Rafiq
> <>

Received on Thu Feb 26 2009 - 00:12:47 CST

Original text of this message