Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> temporary tablespaces
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
Received on Fri Sep 12 2003 - 09:19:14 CDT