15.00 - EnabNonTempoOp - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

EnabNonTempoOp

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.

Caution:

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.