Re: [Q] way to shrink temporary tablespace ??
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: Cannot grant quota on the tablespace
See Metalink Doc ID: 331657.1
Paul Drake <email@example.com> wrote:
On 1/19/06, Joseph Amalraj <firstname.lastname@example.org> 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
> Joseph Amalraj