15.10 - ReconfigRedistOrderV - 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 Name

Data Type

Format

Source Table.Column

OrderNumber

INTEGER

NOT NULL

ZZZZZZZZZ9

ReconfigRedistOrderTbl.OrderNumber (UPI)

DatabaseName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

ReconfigRedistOrderTbl.DatabaseName (USI)

TableName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

ReconfigRedistOrderTbl.TableName (Composite USI)

ProcessOffline

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

ReconfigRedistOrderTbl.ProcessOffline

The ReconfigRedistOrderV view provides the end user a way to access the ReconfigRedistOrderTbl. Users with the appropriate privileges can SELECT, INSERT, UPDATE, or DELETE on the base table via the view.

Note: 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.)