Teradata Database Message 3772 - 3772 - Analytics Database - Teradata Vantage

Message

You cannot DROP a journal that is the default for other databases.

Explanation

An attempt has been made, in MODIFY DATABASE, to drop the permanent journal table in that database, but there is at least one other database that specifies the table as its default permanent journal. Journal tables may not be dropped when they are currently listed as defaults in other databases, even if no table is actually using them.

Generated By

OPT modules.

For Whom

End User.

Notes

None

Remedy

Either turn default journaling off for the other database using this journal, or assign default journaling to some other journal. MODIFY DATABASE must be used to turn default journaling off or to change the default journal table assignments.