|
>"Daniel Westermann (DWE)" <daniel.westermann@xxxxxxxxxxxxxxxx> writes:
>>> People have asked about this before, so maybe it'd be an idea to make
>>> an explicit concept of a temp tablespace that only accepts temp tables, >>> and do whatever is needful to make that robust. But I've not heard of >>> any work towards that. >> That's what I thought temp_tablespaces are for ( plus sorts, temporary files getting created by materialized views ... ) >No ... temp_tablespaces says it's okay to use any of the listed >tablespaces to keep temporary working files in, but it doesn't >say that those tablespaces can *only* be used for that. Ok, understood. For me, at least, it sounds weird to put anything other than real temporary stuff in there.
>The whole business of temp tables (as opposed to those invisible-to-SQL
>working files) in such a tablespace is a separate issue, too. I think >that the server would mostly survive having temp-table files disappear >during reboot, but it's not an officially supported or tested scenario. Thank you, that is what I wanted to know. I works for all the cases I tested, but it is not officially supported.
Regards
Daniel
|
