maintenance and user considerationSounds like your not getting the support
to do something about the users. Here's what we do. All users who need to
create tables but don't like quotas get assigned the same default tablespace
(60 Gb in size). They can do what they like with this space. Every 1/2 hr
the default tablespace is queried and if it's 80% full, the admin user for
this tablespace gets an email. If it's at 90%, everyone gets an email with a
listing of the top 10 worst offenders. They are then responsible for
deciding who or what user has to delete their tables.
----- Original Message -----
From: Johnson, Shaunn
To: LazyDBA.com Discussion
Sent: Thursday, July 31, 2003 1:51 PM
Subject: maintenance and user consideration


Howdy:
DBA's - how do you keep your users from creating tables
at will and taking up too much room with useless tables?
I understand that there is quota functionality, but my
users can't work very well with that - on the other hand,
I can't *make* them keep the naming convention that we've
assigned for temp tables (or, even use the 'create temp table'
in their SQL scripts) and drop THOSE every few weeks.
So, how do I police their usage without removing "important"
data?
Suggestions?
Thanks!
-X
Oracle LazyDBA home page