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.)
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.