Archives of the TeradataForum

Message Posted: Thu, 04 Feb 2010 @ 14:15:28 GMT

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

If one database is the immediate owner of the other you can do that simply by modifying the child database - changing its Permspace.

Otherwise you need to create a temporary database from the one you want to remove space from. Then GIVE that database to the other database, and finally DROP the temporary database.

You can turn this into a script or Stored Procedure if you want. (You would need to use dynamic SQL in your SP and you might have access rights problems unless you created the SP as a user who had Drop access to all databases)

Alternatively just use Teradata Administrator's Tools>Move Space menu if you only need to do this occasionally. (Or use the Space portlet in Viewpoint)

Mike Dempsey
Teradata Client Tools

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