Re: How to get rid of temp segments (7.3) without shutting down database ?

From: Steve Dodsworth <steven_dodsworth_at_qsp.co.uk>
Date: 1996/12/10
Message-ID: <01bbe695$416256e0$5e0285c1@pc363.qsp.co.uk>#1/1

The temporary segments should periodically be cleaned up by the smon background process.

Change the temporary tablespace for the index owner to be something other than the index tablespace to avoid fragmentation.

-- 
Regards
Steve



Pierre <maverick_at_videotron.ca> wrote in article
<58ft3k$1km_at_wagner.spc.videotron.ca>...


> 

> 

> 	We're working with very little resources, hence the database

> 	has practically no sort area size. Every index created

> 	generates a duplicate temp segment in it's tablespace.

> 	How do we get rid of those segments without shutting down 

> 	the db.

> 

> 		Thanks for a reply. E-mail please to

> 

> 		proussin_at_m3isystems.qc.ca

> 

>

Received on Tue Dec 10 1996 - 00:00:00 CST