way to shrink temporary tablespace ?? 2006-01-19 - By Joseph Amalraj
I got the following error:
SQL> alter user scott quota 1M on temp;
alter user scott quota 1M on temp
*
ERROR at line 1:
ORA-30041 (See ORA-30041.ora-code.com): Cannot grant quota on the tablespace
See Metalink Doc ID: 331657.1
Regards
Joseph Amalraj
Paul Drake <bdbafh@(protected)> wrote:
On 1/19/06, Joseph Amalraj <joseph@(protected)> wrote:
>
>
> Probably 2 temporary tablespaces can be created. Users writing poor queries
could be assigned to one of them, and critical applications use the other
temporary tablespace.
>
> Unfortunately Oracle does not allow quotas on temporary tablespace.
>
> Regards
>
> Joseph Amalraj
<DIV>I got the following error: </DIV> <DIV> </DIV> <DIV>SQL> alter
user scott quota 1M on temp;<BR>alter user scott quota 1M on temp<BR>*<BR
>ERROR at line 1:<BR>ORA-30041 (See ORA-30041.ora-code.com): Cannot grant quota on the tablespace</DIV> <DIV
> </DIV> <DIV> </DIV> <DIV>See Metalink Doc ID: 331657.1</DIV> <DIV
> </DIV> <DIV>Regards</DIV> <DIV> </DIV> <DIV>Joseph Amalraj<BR><BR
><B><I>Paul Drake <bdbafh@(protected)></I></B> wrote:</DIV> <BLOCKQUOTE
class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff
2px solid">On 1/19/06, Joseph Amalraj <<A href="mailto:joseph@(protected)
">joseph@(protected)</A>> wrote:<BR>> <BR>> <BR>> Probably 2
temporary tablespaces can be created. Users writing poor queries could be
assigned to one of them, and critical applications use the other temporary
tablespace. <BR>> <BR>> Unfortunately
Oracle does not allow quotas on temporary
tablespace. <BR>> <BR>> Regards
<BR>> <BR>> Joseph Amalraj <BR><BR><
/BLOCKQUOTE>
|
|
