DATABASE MANAGE Command | unityadmin | Teradata Unity - DATABASE MANAGE - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
fmz1594836948704.ditamap
dita:ditavalPath
qqk1595871525984.ditaval
dita:id
B035-2520
Product Category
Analytical Ecosystem

Purpose

Changes the managed location of all tables in the specified database to the specified systems.

Syntax

DATABASE MANAGE {<database> [ON <tdpid>[,…]]} [REASON '<reason>']

Example

unityadmin> database manage dbtest on db1;
                Table "dbtest.test0" de-activated on :
                                2 (db2)
                Table "dbtest.test1" de-activated on :
                                2 (db2)
                Table "dbtest.test2" de-activated on :
                                2 (db2)
                Table "dbtest.test3" de-activated on :
                                2 (db2)
                Table "dbtest.test4" de-activated on :
                                2 (db2)
  Location of all specified object(s) have been modified.