16.10 - Reallocating Perm Space to Resolve Space Issues - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
Release Date
April 2018
Content Type
Publication ID
English (United States)
  1. In the Space Usage portlet, highlight the database or user that requires more space.
    You can also define the value for spool in a profile, and then assign profile membership to a user. See Creating Profiles.
  2. Click the Add Space button and:
    • Enter your username and password (you must have DROP privileges on the database or user that requires more perm space).
    • Enter the space in megabytes and the name of the user or database that directly owns the perm space being transferred.

    The system generates a MODIFY DATABASE or MODIFY USER statement that reallocates the space.