Re: TEMP tablespace again

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