Reallocating Perm Space to Resolve Space Issues - Teradata Database

1 In the Space Usage portlet, highlight the database or user that requires more space.

Note: You can also define the value for spool in a profile, and then assign profile membership to a user. See “Creating Profiles” on page 109.

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.