Archives of the TeradataForum

Message Posted: Wed, 06 Nov 2002 @ 15:01:45 GMT

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

I have a question related to the current thread concerning the difference between user/non-user databases.

We recently discovered that at least one function (issue DDL from within a stored procedure) requires that the procedure be stored in perm space within the user database that is going to execute the stored procedure.

At our installation, we don't allocate perm space to user databases. (in general)

Are there other functions or reasons that might warrant allowing a user database to have perm space? Any pros/cons to consider either way?

Thanks

Jim

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