Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: temporary tablespaces
David COSTE wrote:
> Hello,
>
> I am using Oracle 9.2.0.3 on HPUX
> I would like to konow if there is a way to force a user to use another
> temporary tablespace than it's default one.
> This is because I 've got the same database user that performs datawarehouse
> style queries, and batchs and I would like to use a different temporary
> tablespace in order for to prevent the batch activity to be disturbed by the
> other queries.
> I know it would have been better to have different users but for some reason
> it is not possible.
>
> Thanks in advance
> David Coste
> OCP 8i
>
>
Fail to see what activity has to do with temp tablespace.
As you use 9.2, assume your ts are LMT, as well as ASM?
So, what's the difference in having two TEMP tablespaces,
or just adding file(s) to the one you have?
-- Regards, Frank van BortelReceived on Fri Sep 12 2003 - 09:39:15 CDT