RE: mystery object
Date: Wed, 25 Feb 2009 11:32:29 -0500
If you are using dictionary managed tablespace then you need to offline that tablespace and online it again to get rid of this object. You may do it around off peak time to avoid any production down time.
Please also check why data tablespace is being used instead of temp tablespace. It is normally appearing in dictionary managed temp tablespace and it may be result of some failed process of table/index rebuidling as explained in the following email.
Hope this help.
> Date: Wed, 25 Feb 2009 22:44:17 +0800
> To: howard.latham_at_gmail.com; oracle-l_at_freelists.org
> From: hkchital_at_singnet.com.sg
> Subject: Re: mystery object
> It is the result of either of a
> a. CREATE TABLE AS SELECT
> b. CREATE INDEX
> c. ALTER TABLE .. MOVE
> d. ALTER INDEX ... REBUILD
> in progress. Each of these operations create a "Temporary"
> segment. On successful completion, the "Temporary" segment becomes a
> "Permanent" Table or Index segment (as the case may be).
> for examples.
> Hemant K Chitale
> At 10:26 PM Wednesday, you wrote:
> >Oracle 10g Redhat linux 32bit
> >I have a mystery object in a data tablespace anyone know what it might be?
> >Its big 149 Gigs!
> >Name 68.9
> >Type TEMPORARY
> >Bytes 1.4011E+11
> >Howard A. Latham
Windows Live™: Discover 10 secrets about the new Windows Live. http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!550F681DAD532637!7540.entry?ocid=TXT_TAGLM_WL_t2_ugc_post_022009 Received on Wed Feb 25 2009 - 10:32:29 CST