Hacker News new | ask | show | jobs
by hrktb 5614 days ago
Reverting a full db should be straightforward (stop the db server and revert a dump).

For a single account it's more of a pita.

Retrieving all the datas associated with one account, put it in a format readable from the production environment and recommit all the changes while dealing with the potential errors and inconstencies seems quite a huge deal.

Messing unrelated data in the process would also be a nightmare.

Of course, not deleting anything from the start wouod be the way.

1 comments

It's trivial in Oracle, just do a Flashback Query. You would just need to support that in whatever front end interface the customer support people use.