> Very cooll, Rich! I have a shell script that monitors temp and undo usage > in the main systems and if it hits a certain threshold I've set for that > database, it sends an email alert to the appropriate folks. The developers > on that list do NOT like to see their names on the email alert, as it means > they may be impacting production and it means our boss may be coming over to > their desk in a short period of time to visit... :) I saw the writing on the wall one day after and did the following: ALTER USER developer TEMPORARY TABLESPACE developer_temp; Takes at least one worry away from this solo DBA. :) Rich -- //www.freelists.org/webpage/oracle-l