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

-- //

Other related posts: