RE: mystery object
Date: Wed, 25 Feb 2009 11:32:29 -0500
Message-ID: <BAY107-W4573858EBCFED82C8BC571A1AC0_at_phx.gbl>
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.
Regards
Rafiq
> 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).
>
> See
> http://hemantoracledba.blogspot.com/2008/05/temporary-segments-in-dataindex.html
> for examples.
>
>
> Hemant K Chitale
> http://hemantoracledba.blogspot.com
>
> 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
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 25 2009 - 10:32:29 CST