Archives of the TeradataForum

Message Posted: Tue, 03 Apr 2012 @ 09:28:20 GMT

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

There are many reasons to make a local backup copy (if you have the room and the time) before maintenance or change implementation is done.

For me I do not drop anything, I rename if recreating.?? Exception tables that are locked by failed loads that can no longer be released.? I do this for all objects for ease of backing out any changes, simply rename again..?

I do this in all environments no matter what the instructions are from developers.? I often get requests that specify perserve the data, but the DDL they provide the first line is drop