Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Stored Procedure to Move the Space From Database To Database
From:   Dempsey, Mike

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023