15.00 - 5969 The database '%VSTR' has tables with error tables defined in another database. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

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