Permanent journal

Database

Permanent journal

Hi All,

I am creating before and after journal in table but i m getting error like " Database does not have permanent journal ". Please tell me how to solve this error.

Thanks

Ranga

1 REPLY
Teradata Employee

Re: Permanent journal

Since you didn't specify a journal table name in the CREATE TABLE, it will use the default journal table for the database in which the table is defined.

You can use MODIFY DATABASE to set a DEFAULT JOURNAL TABLE for the database. The system will create a new journal table if the specified default is in the database being modified and does not already exist.