Re: Quota on TEMP

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Thu, 21 Sep 2006 00:47:47 +0800
Message-Id: <7.0.1.0.0.20060921004657.01bacdc0@singnet.com.sg>

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

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

Received on Wed Sep 20 2006 - 11:47:47 CDT