Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to restore the deleted table by misoperation by Oracle". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "how to restore the deleted table by misoperation by Oracle"!

1. Two methods of deleting data from a table

A. Delete * from table

B. Truncate table table

two。 Delete the entire table

Drop table table

How to recover a watch accidentally dropped by drop? there is a similar "Recycle Bin" in Oracle.

For example, accidentally delete the table:

Drop table table_name

At this point, when you query the table with the select statement, the table will be prompted or the attempt will not exist.

However, you can restore it with the following statement:

FLASHBACK TABLE my_table to before drop

Delete the method that table does not enter recycle:

Completely delete a table:

Drop table table_name purge

At this point, I believe you have a deeper understanding of "how to restore the deleted table by misoperation in Oracle". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.