OBJECT PROMOTE - Teradata Unity

Teradata® Unity™ User Guide

Product
Teradata Unity
Release Number
16.20
Published
May 2019
Language
English (United States)
Last Update
2019-05-23
dita:mapPath
dzf1517499323110.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

Purpose

Changes state of a table object to the Restore state. After recovery completes, the table object state changes to the Active state.

Syntax

OBJECT PROMOTE {tablename [ON tdpid [, tdpid, ...]]} [ REASON reason];

Parameters

ON
Change a table on a specific Teradata Database system.
tdpid
Unique identifier (TDPID) of a Teradata Database system.
REASON reason
User description of why the object is having its state changed.
tablename
The fully qualified table name if you are attempting to change the state of a table.

Usage Considerations

When you perform a state change for a specified Unity managed table object, the table object changes to Active state on all the Teradata Database systems managed by Unity on which it resides. When promoted, the table object state changes to the Restore state and then, after the data recovery operation completes, changes to the Active state.

Example

The following example promotes an object t4_cp from a Teradata Database cp_tpp004u to the Active state on the Teradata Database system cricket.

unityadmin>  OBJECT PROMOTE cp_tpp004u.t4_cp ON cricket;