Re: How to get rid of temporary segments

From: <yong321_at_yahoo.com>
Date: Tue, 05 Dec 2000 23:36:15 GMT
Message-ID: <90ju5f$9a$1@nnrp1.deja.com>

How do you know that's going to cause a problem? If I were you, I wouldn't do anything.

Yong Huang
yong321_at_yahoo.com

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 Tue Dec 05 2000 - 17:36:15 CST