 |
 |
Archives of the TeradataForum
Message Posted: Tue, 12 May 1999 @ 00:09:29 GMT
| Subj: | | Re: Default database space |
| |
| From: | | John K. Wight |
There is also another school of thought that I have worked in a customer environment and that is each user has it's own database
space and can create as much in that space as is available. It helps the DBA to monitor user usage, requirements, etc. And when a
user needs more space (usually as they mature and get created more sophisticated -identified through monitoring usage over time). In
this scenario, there is no problem of duplicate table names other than the user trying to create a table with the same name that
they created before and forgot to drop - but that is a different issue. I prefer this approach and allocate all users xMB's of space
initially and let them contact help desk, DBC, etc. when they need more. This allows you to monitor usage, assist in supporting
usage/techniques, etc. And allocate more space when needed, etc. I can then do usage analysis by user to see what each one is
using, % of total, etc.
Just another way o look at the world.
JK
John K. Wight
Senior Solutions Consultant - Retail Solutions Group
NCR Corp.
| |
