1

I have a tableTest .

It was created like this : 

CREATE SET TABLE mydbname.Test,FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO
     (
      nameid INTEGER)
PRIMARY INDEX ( nameid);

Is there any way I can restore the data if I delete all rows DELETE FROM Test ?

Is there any way to undo DELETE for a Teradata table?

Alex
  • 355
  • 7
  • 25
  • Presumably you have backups? If not, then the data's gone. Regardless, offtopic - not a programming question. We are not general server/DB tech support. – Marc B Jan 07 '15 at 19:14
  • 'fallback' only works for 'drop' ? – Alex Jan 07 '15 at 19:24
  • 3
    DELETE can only be rolled back if the transaction is not yet committed. FALLBACK only protects from hardware errors (i.e. an AMP looses it's disk) not from stupid users :-) – dnoeth Jan 07 '15 at 20:11

0 Answers0