DATABASE MANAGE - Teradata Unity

Teradata® Unity™ User Guide

Product
Teradata Unity
Release Number
16.50
Published
January 2020
Language
English (United States)
Last Update
2020-02-04
dita:mapPath
frp1571162435023.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.