Re: Drop a Temporary Segment
Date: Mon, 2 Jul 2012 17:11:53 +0800
Message-ID: <CALHwA6Ak=HYgxZJv9kK478i3axUOJh=J_qD=HLj9cMw9rs5nrg_at_mail.gmail.com>
Hi,
You can use the following link to cleanup the temp segment:
http://askdba.org/weblog/2009/07/cleanup-temporary-segments-in-permanent-tablespace/
Regards,
Saurabh Sood
www.askdba.org/weblog
On Thu, Jun 28, 2012 at 5:31 AM, <japplewhite_at_austinisd.org> wrote:
> 64bit Oracle10g 10.2.0.4 EE on Linux. Locally-managed tablespaces.
> Earlier today I did a Segment-Exchange on a large table with a huge
> out-of-line LOB Segment. The empty single partition exchanged-into table
> had local indexes and all the structures matched. The Segment Exchange
> was successful. I then mistakenly did a Truncate Table on the now huge
> partitioned exchanged-into table. That ran for hours until I killed it -
> my 2nd mistake. I then did a Drop Table on it, which completed in
> seconds. However, now I have a 56 GB Temporary segment named 10.5755 in
> the tablespace designated for LOB storage. This is a Production database
> so I can't bounce it in hopes that SMon will clean it up. It has
> persisted for a couple hours now.
>
> How do I get rid of it? I tried Alter Tablespace xxxxx Coalesce, but that
> didn't do the trick.
>
> BTW, when do you think this Temp segment got created, during the Segment
> Exchange, the Truncate, or the Drop?
>
> Thanks.
> ----
> Jack C. Applewhite - Database Administrator
> Austin I.S.D. - MIS Department
> 512.414.9250 (wk)
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- -- Saurabh Sood -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 02 2012 - 04:11:53 CDT