Archives of the TeradataForum

Message Posted: Mon, 20 Mar 2006 @ 21:17:54 GMT

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

Cassiano,

Id you are at V2R5.1 or higher you can abort rollback, but the table becomes unusable. Except you can still move the data over to new table.

Directions are in Utilities Volume 2 manual under Recovery Manager and command CANCEL ROLLBACK ON TABLE you can find table id in dbc.tvm

Don't forget the LOCK ... for READ OVERRIDE so you can get the current contents.

Thanks,

Bob Diehl

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