Re: temporary segments

From: David F. Newman <buzzwang_at_churchill.ourvillage.com>
Date: 28 Sep 1999 10:27:54 -0400
Message-ID: <86ogenxg9g.fsf@churchill.ourvillage.com>

Kenneth C Stahl <BlueSax_at_Unforgettable.com> writes:

> That doesn't answer the question. Do you have temporary tablespace for SYS
> or SYSTEM pointed at the tablespace which you have designated for temporary
> segments? If so, then either SYS or SYSTEM is building temporary segments
> there and it is quite normal. If you want to get rid of them, point
> temporary tablespace for SYS and SYSTEM at the SYSTEM tablespace and then
> bounce the database. At that point you should be able to shrink the
> tablespace.
>

If the database is bounced then won't the temporary segments go away? And then when the database comes back up and sys and system start generating temporary segments again won't they start at the beginning of the tablespace and not at the end?

--
David F. Newman
Oracle DBA
dnewman_at_ourvillage.com Received on Tue Sep 28 1999 - 09:27:54 CDT