hi,
we have a temporary tablespace which is set as the temporary tablespace against a user.
However, the tablepsace is always empty (only header info in it)
Presumably the actual tablespace being used by that user is a different tablespace to the default?

How can I tell which tablespace is actually being used for that user, as opposed to the default ts specified.
Also, how is it possible to use another one anyway? - can it be specified somewhere in the sql statements etc- I am not aware of this being possible?

Am I right in thinking that if the ts is basically empty that it has never been used, or does it fill up and empty again depenant upon wha the user is doing, and so if it is empty then tht does not necessarily mean it is not being used at some point?