Shulou(Shulou.com)06/01 Report--

What this article shares to you is a detailed introduction of how ORACLE restores the table data of delete. I believe most people have not yet learned this skill. In order to make you understand better, I have summarized the following content for you. Without saying much, let's read on.

Find the SCN number in the redo log file, then narrow the SCN number range, and find the data to be recovered.

Step 1: select dbms_flashback.get_system_change_number from dual;-- > find the current SCN number (7455407 here). It's even easier if you know the SCN number before deleting the data.

Step 2: select count (*) from T1 as of scn 7455407-> query the data under the current SCN (0 is currently found because the data has been deleted)

Step 3: narrow the scope of SCN, that is, push forward.

Select count (*) from T1 as of scn 7433000 words-> data were found at this point (17110 items).

Step 4: insert into T1 select * from T1 as of scn 7443000-> recover data

These are the details of the table data that ORACLE recovers from the delete. The code example is simple and clear, if you encounter this problem in your daily work. Through this article, I hope you can get something. For more details, please follow the industry information channel!

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.