Archives of the TeradataForum

Message Posted: Mon, 10 May 1999 @ 18:46:57 GMT

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

Dean,

Typically at most sites, the user's database has no space. The tables themselves are then set up in any number of subject area databases. If two users try to create the same table name in the same database, only one will be successful. Options to get around this would be to use some unique identifier on each temp tablename, such as append the userid, or they could use derived tables.

Mark Andrews
Sr. Teradata DBA
Delta Technology Inc.

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