Archives of the TeradataForum

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

	<Prev	Next>		<<First	<Prev	Next>	Last>>