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;