Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to get rid of temporary segments

Re: How to get rid of temporary segments

From: <ashish25_at_my-deja.com>
Date: Wed, 06 Dec 2000 15:33:18 GMT
Message-ID: <90lm7u$b8a$1@nnrp1.deja.com>

Hi,

   Here is how you can get rid of temporary sticking segments. 1)alter your temporary tablespace to permanent.

2)Create a table in this tablespace
  create table temp_tb(doodle NUMBER(10) tablespace tbs_name    storage(initial 1M,Next (big enough so it is not able to allocate) minextents 2);
3)The create table will fail and SMON will clear up your tablespace. 4)Alter the tablespace to temporary.

Thanks,
Ashish

In article <amtq2t45qptulapi2r959ei9f8e9pjtncb_at_4ax.com>,   Yurasis Dragon <yurasis_spamNOSPAM_at_yahoo.com> wrote:
> Short of bouncing a database how do I get rid of
> temporary segments. I have one, owned by SYS,
> that is almost 2 gb in size and will cause problems
> if we have a big sort occuring anytime soon.
>
> Any ideas? Thanks in advance.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 06 2000 - 09:33:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US