Thanks for the reply sudhir!

Well thats what I was doing exactly but because I was initially Truncating the tables instead of Delete, I was not able to rollback.

Got it...