Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 07 Jun 2012 @ 17:23:42 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Deleting records from DBC.TransientJournal table
From:   Diehl, Robert


Transient journal is the table that is used to rollback failed transactions.

Transient journal would be used for inserts/deletes/updates.

When you delete rows from a table the rows will be placed into the transient journal so they can be put back into the original table if the delete query fails or is aborted. Once the insert/update/delete is complete/committed the rows are removed from the transient journal.


Robert Diehl
Travelocity Data Warehouse DBA

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019