Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 19 Feb 2005 @ 22:22:58 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Deleting the partial rows
From:   Anomy Anom

<-- Anonymously Posted: Saturday, February 19, 2005 17:06 -->

  But here there is no proper backup is available so we need to search for the alternative way. so please suggest if any other way is there.  

If you have no previous versions of the table and you have no date it would appear there is only one other solution:

Since it is a very small table of 10K worth of rows, you might go to your users who entered them and ask when each was entered. Then you will have everything you need to delete them.

Otherwise, do the sensible thing and get a date column into the table NOW. Then one day you will be able to delete all the rows without a date. In addition, you will have a basis for doing more deletes in the future.

Good luck

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023