Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: temporary tablespaces
It's because my batch processing consumes temporary segments and I don't
want to see it run out of space because some one would have launched a big
query with an order by.
The idea is to avoid sharing the same temp tablespace for the 2 activities.
"Frank" <fvanbortel_at_netscape.net> wrote in message
news:bjsleq$j1h$1_at_news4.tilbu1.nb.home.nl...
> 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 Bortel
>
Received on Fri Sep 12 2003 - 10:12:46 CDT