DATABASE MANAGE - 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 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.