Deleting All Objects from the Teradata Database - Teradata Tools and Utilities

Teradata® Archive/Recovery Utility Reference

Product
Teradata Tools and Utilities
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-06-05
dita:mapPath
fac1527114221922.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
Product Category
Teradata Tools and Utilities

In order to restore database DBC, no objects can exist in any database outside of DBC. Delete all objects outside of DBC prior to restoring DBC by using this command:

DELETE DATABASE (DBC) ALL, EXCLUDE (DBC);

To drop permanent journal tables, use MODIFY USER or MODIFY DATABASE. See the MODIFY DATABASE/USER description in SQL Data Definition Language (B035-1184).

Enter the command exactly as shown above. Specifying SYSUDTLIB as an object of this DELETE DATABASE statement is not required. Teradata ARC removes the usual link between SYSUDTLIB and DBC so that only DBC is excluded from the delete operation. SYSUDTLIB is deleted so that DBC can be restored, however, it is deleted after all other databases have been deleted. This allows any objects that have definitions based on UDTs stored in SYSUDTLIB to be deleted before the UDTs themselves are deleted.