All Forums Database
muthu1802 20 posts Joined 01/12
23 Apr 2015
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.
 
 

Fred 1096 posts Joined 08/04
28 Apr 2015

No. Journal table contents are not accessible via SQL.

muthu1802 20 posts Joined 01/12
29 Apr 2015

Thanks Fred.
then to restore the journal content to actual table we need to do a ARCHIVE & RESTORE .
Am I right. ?

You must sign in to leave a comment.