Archives of the TeradataForum

Message Posted: Tue, 12 May 1999 @ 00:09:29 GMT

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.