Re: mystery object
From: Yechiel Adar <adar666_at_inter.net.il>
Date: Thu, 26 Feb 2009 08:12:47 +0200
Message-id: <49A632DF.6030504_at_inter.net.il>
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.
Date: Thu, 26 Feb 2009 08:12:47 +0200
Message-id: <49A632DF.6030504_at_inter.net.il>
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
>
>
> <http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns%21550F681DAD532637%217540.entry?ocid=TXT_TAGLM_WL_t2_ugc_post_022009>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 26 2009 - 00:12:47 CST