Re: Temp Tablespace Question

From: <bdbafh_at_gmail.com>
Date: 4 Mar 2005 15:02:47 -0800
Message-ID: <1109977367.225418.207430@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 Received on Fri Mar 04 2005 - 17:02:47 CST