Adjusting Perm Space Limits Using Viewpoint - Teradata Database

Adjusting Perm Space Limits Using Viewpoint

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.

2 Click the Add Space button and:

Enter the username and password of a database user that has DROP privileges (required for use of the MODIFY statement) 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.