Re: Temp Tablespace Question

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Fri, 04 Mar 2005 23:26:26 GMT
Message-ID: <C86Wd.70941$H05.37238@twister.nyroc.rr.com>

<bdbafh_at_gmail.com> wrote in message news:1109977367.225418.207430_at_o13g2000cwo.googlegroups.com...
> use tablespace quotas.
>
> the relevant view is dba_ts_quotas.
>
> Far better for bad sql to fail on a quota exceeded than having no free
> space on the filesystem (or mount point).
>
> e.g:
> SQL> alter user <app_user> quota 1024M on temp;
>
> I can recall in 7.3 (before I was a DBA) a user had a permanent
> tablespace set as hit temp tablespace ... his query failed when the
> file extended to the OS limit (was a 4KB blocksize). you're in for some
> serious maintenance to reclaim that space.
>
> -bdbafh
>

I don't understand what you are suggesting here? If temp is a temporary tablespace then your quota command will be ignored. You cannot assign quota to users on temporary tablespaces.

Anurag Received on Fri Mar 04 2005 - 17:26:26 CST