Teradata Database Message 5969 - 5969 - Analytics Database - Teradata Vantage

Teradata® VantageCloud Lake - Analytics Database Messages

Edition
Lake
Product
Analytics Database
Teradata Vantage
Published
October 2022
Language
English (United States)
Last Update
2024-02-26
dita:mapPath
tzr1629746512312.ditamap
dita:ditavalPath
ft:empty
dita:id
vza1585613049811
lifecycle
latest
Product Category
Teradata® Vantage™
Message
The database '%VSTR' has tables with error tables defined in another database.
Explanation
The above error is generated when a user submits a DELETE DATABASE command on a database that contains tables with error tables defined in some other database. The DELETE is disallowed in order to avoid orphaned error tables.
Generated By
OPD module(opddeldb)
For Whom
End User or Field Engineer or the concerned site support Representative.
Notes
Find all the error tables that are defined on the tables in the database being deleted by using the following command: SELECT BaseTblDbName, BaseTblName, ErrTblDbName, ErrTblName FROM DBC.ErrorTblsV WHERE BaseTblDbName <> ErrTblDbName AND BaseTblDbName = CurrentDBName; where <CurrentDBName> is the database name of the database being deleted.
Remedy
Drop all error tables from the above list and re-submit the DELETE DATABASE command.