Deleting - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

To prepare a system for restoring Database DBC, use the DELETE command to delete all objects in the system except for permanent journal tables. (To drop permanent journal tables, use either the MODIFY USER or MODIFY DATABASE statement.)

delete database (DBC) ALL, exclude (DBC);

When the EXCLUDE DBC option is used with the (DBC) ALL option on a DELETE DATABASE statement, SYSUDTLIB is delinked from DBC. This allows SYSUDTLIB to be deleted so that DBC can be restored. However, SYSUDTLIB is deleted last, after all other databases have been deleted. Any objects that have definitions based on the UDTs stored in SYSUDTLIB are deleted before the UDTs themselves are deleted.

If the EXCLUDE option is used to exclude DBC on a DELETE DATABASE statement, but the (DBC) ALL option is not used, SYSUDTLIB continues to be linked to DBC. DBC and SYSUDTLIB are excluded from the delete operation.

Do not specify SYSUDTLIB as an object of the DELETE DATABASE statement.