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 -> Re: temporary tablespaces

Re: temporary tablespaces

From: David COSTE <dco_at_compaq.com>
Date: Fri, 12 Sep 2003 15:12:46 GMT
Message-ID: <Onl8b.4630$je2.2848@news.cpqcorp.net>


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

Original text of this message

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