How to read Journal Table in teradata ?

Database

How to read Journal Table in teradata ?

Are the journal table data's are readable ? If yes , can we select it using simple SQL (select *) ?

or How to read Journal Table data ?

please suggest.

Thanks,

Muthu.

2 REPLIES
Teradata Employee

Re: How to read Journal Table in teradata ?

No. Journal table contents are not accessible via SQL.

Re: How to read Journal Table in teradata ?

Thanks Fred.

then to restore the journal content to actual table we need to do a ARCHIVE & RESTORE .

Am I right. ?