16.10 - EnabNonTempoOp - 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

Purpose

Determines whether NONTEMPORAL operations can be used.

NONTEMPORAL operations delete rows, modify history rows, or change Transaction Time column values on temporal tables that include a Transaction Time column. These operations include NONTEMPORAL DELETE, NONTEMPORAL UPDATE, NONTEMPORAL INSERT, NONTEMPORAL CREATE TABLE AS, and NONTEMPORAL ALTER TABLE.

The NONTEMPORAL privilege allows a user to circumvent the automatic history that is kept for tables with transaction time. It allows users to perform operations that would otherwise not be allowed on these tables. For purposes of data security and integrity, Teradata recommends that the EnabNonTempoOp setting remain unchanged from the default, so that NONTEMPORAL operations are blocked, unless absolutely necessary.

Field Group

General

Valid Settings

Setting Description
TRUE Nontemporal operations can be performed on temporal tables.
FALSE Nontemporal operations cannot be performed on temporal tables.

Default

FALSE

Changes Take Effect

After the DBS Control Record has been written.

Usage Notes

Leave this field set to FALSE to prevent inadvertent and unauthorized modifications to temporal tables that include transaction time. Enable this setting only when nontemporal operations are necessary, as for deleting very old history rows or fixing problems with temporal tables.

Related Topics

For more information on temporal operations, see Temporal Table Support.