Archives of the TeradataForum

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

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

Hi,

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>>