15.00 - Two MODIFY Requests Required to Change Default Journal Table - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

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

Two MODIFY Requests Required to Change Default Journal Table

Two MODIFY requests are required to change a default journal table that resides in the user space being modified.

1 The first request drops the present journal table from Teradata Database.

2 After the table is dropped, a second request is required to define a new default journal table.

Teradata Database aborts the request and returns an error message to the requestor if the journal table is being used by active data tables.