To free up temp space after sorts, you need to change the temporary
tablespace to the type permanent. This may sound confusing but it works.
"Allen" <aprinsloo_at_websoft.co.za> wrote in message
news:236c75fa.0303280302.64b114ab_at_posting.google.com...
> Hi,
>
> Due to my limited Oracle experience this question might seem a bit
> basic, but I'd appreciate any help.
>
> Product: Oracle 8.1.6
> Platform: MS Server 2000
>
> How do I clean out the space used by the temp table space on our
> Oracle database server. The temp table space is of type "tempory" but
> keeps filling up and growing, is there a way to automate the clean out
> of it or do I need to manually do something to it?
> Previous dbms's I've worked on Sybase and MS Sql Server cleaned out
> tempory db work space after every commited transaction, this does not
> seem to be the case with Oracle... or am I msitaken?
>
> Thx in advance
> Allen
>
Received on Sat Mar 29 2003 - 15:37:29 CST
