16.10 - Syntax - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Update Space presents a command-line environment that allows the entry of the UPDATE command, which has the following syntax.



TEMPORARY
Specifies to update only the temporary space.
ALL
Specifies to update all the space.
SPOOL
Specifies to update only the spool space.
Spool space can be calculated for a single database only.
PSPOOL
Specifies to update only the spool space that persists across restarts.
SPACE FOR
Specifies the name of the database(s) for which space is to be recalculated.
ALL DATABASES
Specifies all the databases in a system.
dbname
Specifies the name of a single database.
ALL PROXYUSERS
Specifies to update the specified space for all Trusted Sessions proxy users.