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.