Re: temorary segments

chuckh_at_ix.netcom.com (Chuck Hamilton) wrote:
>I'm having problems with a 7.1.3 database not cleaning up TEMPORARY
>segments after dropping tables. What can I do short of bouncing the
>database to make it clean them up?
>
>The process I'm running drops all snapshots in a schema and recreates
>them (much faster than doing a complete refresh) but the tablespace
>runs out of space because the temp segments are constantly hanging
>around.
>--

Try to create a table in that tablespace. It will release the temporary segments.

Richard Received on Mon Feb 05 1996 - 00:00:00 CET