`
xiechangming
  • 浏览: 26668 次
  • 性别: Icon_minigender_1
  • 来自: 上海
社区版块
存档分类
最新评论

How to recovery data /table

 
阅读更多

If you drop a table or delete data mistakenly, then want rollback them, you can take the following methods:

  1.  Query the data before delete:

Select * from table_name as of timestamp date_before_delete.

Once you get the data before delete operation, how to recovery the data is needless to expatiate.

  2.  Flashback dropped table:

Flashback table table_name to before drop;

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics