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: TEMP tablespace again

Re: TEMP tablespace again

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 14 Mar 2001 15:56:59 -0000
Message-ID: <984585232.29224.2.nnrp-12.9e984b29@news.demon.co.uk>

Looks like your temporary tablespace is not yet set to 'contents temporary' with the:

Alter tablespace {your tablespace} temporary;

At present this won't work until those dead segments have disappeared. You could try to do a 'wakeup' on smon - otherwise they will either clear some time in the next 3 hours, or when the database is next re-started.

There is an (aging, and no longer totally accurate) article about SMON on my
website that may give you some further
information.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Vadim Grepan wrote in message <3AAF55A5.A4B0D128_at_mail.ru>...

>Hello Jonathan !
>
> Thanks for your hint, news segments are allocated with new size.
>But there are two large segments owned by SYS created before. Is there
>any way to drop or decrease them?
>
>Rgds, Vadim Grepan
>------------------------
>Moscow, Russia
Received on Wed Mar 14 2001 - 09:56:59 CST

Original text of this message

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