Moving Spacing Between Databases and Users - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
15.11
Published
May 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
bpb1467322243715.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
You can move PERM space between databases and users.
  1. In the Navigator, right-click Databases and click Show Databases. A list of the databases and users in the connected system appears in the Object List Viewer. The list is filtered according to any filters you have applied.
  2. In the Object List Viewer, right-click the database or user from which you want to move space, and click Move Space.
  3. In the property form, enter how much space to move and choose the destination database or user.
  4. [Optional] Click the SQL category to see the SQL code that will be executed on the connected system to accomplish the move.
  5. Click Commit. The space is transferred, and a dialog opens to confirm the operation.
  6. Click OK.