Move Spacing Between Databases and Users | Teradata Studio - Moving Spacing Between Databases and Users - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-20
dita:mapPath
rvy1605890559220.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, double-click Databases.
  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 General tab, choose the destination database or user and enter how much space to move.
    As you complete the information, the message area at the top of the form indicates whether enough information is specified to move space from one database to another. If not, a red X icon appears with a message explaining what must be done.
    Option Description
    From Database Select a database from the list of databases defined in the system. Space from the database you select is moved to the database you select in To Database.
    To Database Select a database from the list of databases defined in the system. The database you select in this list receives the space moved out of the database you selected in From Database.
    Bytes To Move Shows the bytes of space to move between the selected databases. The unit denomination depends on whether the KB, MB, GB, or TB button has been selected. You can change the value in the Bytes to Move field by typing the value, clicking the up/down arrows to the right of the value, or by adjusting the Percentage to Move slider (see below).
    Percent to Move Provides an alternate way to specify the amount of space to move. The position of the pointer shows the portion of the From Database free space to move to the database specified in To Database. When you adjust the position of the slider, the amount of space to move is shown in the Bytes to Move field.
    Allocations Displays a table that shows the allocation of used and free space of the selected databases. The values display in the units of the selected KB, MB, GB, or TB button. The table shows both the used and free space for the to and from databases, before and after the selected move is executed.
  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 then OK.