Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 29 May 2012 @ 23:49:19 GMT

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

Subj:   Re: Restoring deleted rows
From:   Mushtak Mirajkar


If the rows are deleted successfully and there is NO BACKUP those rows are gone for ever!

Transient Journal keeps copy of before images until transaction or rollback completes successfully. Once completed before images are deleted from TJ.

Teradata will only rollback if the "Delete Transaction" fails for some reason; if "Delete Transaction" succeeds you will get the message :

     DELETE completed. # rows processed. Elapsed Time = ##:##:##

Mission accomplished!?

Mushtak Mirajkar.

  <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: 28 Jun 2020