Re: Quota on TEMP

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Wed, 20 Sep 2006 09:55:23 -0700 (PDT)
Message-ID: <20060920165523.73961.qmail@web52804.mail.yahoo.com>

By creating a separate Temp, how will that stop the ORA-1652, for a run-away query? The difference is that with ORA-1652, our on-call gets called, and if we had a quota, then the User would get a message (quota exceeded). The intention is to avoid the 1st one.

What did you mean by limit the sizes of Tempfiles?

Thanks for replying,
Deepak

• Hemant K Chitale <hkchital_at_singnet.com.sg> wrote:

>
> If it is a single user (ie database account) that
> you want to restrict why
> not just create a TEMPORARY Tablespace assigned to
> that user alone
> and limit the sizes of the TEMPFILES for that
> Tablespace ?
>

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 20 2006 - 11:55:23 CDT