Archives of the TeradataForum
Message Posted: Thu, 04 Feb 2010 @ 14:15:28 GMT
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)
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023