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

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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.