Re: Quota on TEMP
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: sharmakdeep_oracle@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 21 Sep 2006 00:47:47 +0800
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 ?
At 12:32 AM Thursday, Deepak Sharma wrote:
We have certain Users running queries that frequently
fill-up the TEMP tablespace. Is there a way to
specify quota on TEMP. We are on 10gR2 and I already
found that this stopped working in 10gR2 (it was in
fact a Bug in earlier versions).
Hemant K Chitale
http://web.singnet.com.sg/~hkchital
--
//www.freelists.org/webpage/oracle-l
Other related posts:
