Archives of the TeradataForum
Message Posted: Tue, 29 May 2012 @ 23:49:19 GMT
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 = ##:##:##
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|