Re: temporary tablespaces

Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl> wrote in news:9s95mv89nfnn8l2vhlghj0aql3e5vpic08_at_4ax.com:

> You are misunderstanding me. Even if every individual user would have
> it's own temporary tablespace, he still would be capable to run out of
> space in that individual tablespace. Autoextend doesn't come into
> play, because the way he is approaching it, he would be also afraid to
> run out of disk space.
> The OP is accomplishing nothing, except *believing* he is reducing
> risks. One adequately configured temporary tablespace will do. He
> doesn't seem to want to take that route though, but rather fight
> symptoms by setting up more tablespaces.
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

But creating a new temporary tablespace that only that one user has access to would guarantee him of the availability of all the space in that tablespace. Nobody else could infringe upon it. With a single larger tablespace that could not be guaranteed. Received on Thu Sep 18 2003 - 09:30:56 CDT