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
>
>
>
ALTER USER <username>
TEMPORARY TABLESPACE <temp_tablespace_name>;
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Fri Sep 12 2003 - 19:30:38 CDT