Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> temporary tablespaces

temporary tablespaces

From: David COSTE <dco_at_compaq.com>
Date: Fri, 12 Sep 2003 14:19:14 GMT
Message-ID: <CBk8b.4628$Zd2.980@news.cpqcorp.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US