15.10 - ReconfigDeleteOrderV - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Operations

DBC

 

View Column

Data Type

Format

Source Table.Column

OrderNumber

INTEGER

NOT NULL

ZZZZZZZZZ9

ReconfigDeleteOrderTbl.OrderNumber (UPI)

DatabaseName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

ReconfigDeleteOrderTbl.DatabaseName (NUPI)

TableName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

ReconfigDeleteOrderTbl.TableName (NUPI)

CheckTableOption

Note: This column is reserved for future use.

BYTEINT

ZZ9

ReconfigDeleteOrderTbl.CheckTableOption

ProcessOffline

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

ReconfigDeleteOrderTbl.ProcessOffline

This view provides the users a way to access the ReconfigDeleteOrderTbl. Users with the appropriate privileges can SELECT, INSERT, UPDATE, or DELETE on the base table using the view. Note that only SELECT, INSERT, UPDATE, and/or DELETE should be granted to users by user DBC.

Possible Values for ProcessOffline

Note: For the ProcessOffline column, tables undergoing large-scale changes should not be processed during online redistribution. Flag these tables for offline redistribution by setting this field to Y.

 

Value

Description

Y

Table should be processed (deleted or redistributed) offline during the offline portion of the Reconfig deletion or redistribution phase.

N

Table should be processed (deleted or redistributed) online during the online of the Reconfig deletion or redistribution phase. (This is the default.)

OrderNumber

The OrderNumber column allows gaps in the set of user-defined values (for example, you can have a set of 10 values that include 1, 2, 3, 5, 7, 8, 9, 12, 13, and 18).

For more information about the reconfiguration process and the Reconfig utility, see Support Utilities.