Purpose
Changes state of a table object to the Standby state. The table must be managed by Unity.
Syntax
OBJECT DEMOTE {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 specify a single databasename.objectname, the table object changes to a Standby state on all Teradata Database systems managed by Unity. An administrator can demote a table object to a Standby state only from an Active state.
Example
The following changes a table temporal_user.tab3chld to the Standby state across all managed Teradata Database systems.
unityadmin> OBJECT DEMOTE
-> temporal_user.tab3chld;
The request is currently processing as operation number 2.
Operation Number : 2
Operation Name : Demoting Table
User : admin
User Name : Main Administration User
Progress (%) : 100
Status : Finished (1)
Start Time : 01/18 13:55:56
Finish Time : 01/18 13:55:59
Systems:
[1] bltor - Finished (1)
[2] fast - Finished (1)
Updates:
01/18 13:55:59 [-] Info: Demoting table temporal_user.tab3chld
01/18 13:55:59 [-] Info: Successfully demoted table on 2 systems
01/18 13:55:59 [-] Info: Operation finished