Restore the number of tables deleted by the primary partition-Oracle

This document briefly records the last data recovery process.

The reason is that the user has used the data in the basic data table, and the deleted data is used in another table, in addition, when the data table was created, it was convenient to see that no primary/foreign data relationship was established, A certain operation causes some table data to become a problem (whether it is necessary to establish a primary-foreign relationship or not, otherwise, it is very painful to start the operation ). This error occurs in the application.CodeIs a major bug. That is the culprit in the table structure issue. You should add a disabled note in each base material table andProgramIn addition to the Token, you must use a false token or the token history of the basic information. The system maintenance personnel said that the error was found at today, that is, the date on which I restored the data. The error time was nearly. Fortunately, the System user told me that this program is used. Otherwise, a table is required to check the data before 30 minutes, which is different from the current data range.

 

// This is a data table that is 30 minutes ago today. You can also find the data within a certain period of time.

Select * From hw_vct_regional as of Timestamp to_timestamp ('2017/24 09', 'yyyy/MM/DD hh24 ');

 

// Modified data records

Select * From hw_vct_regional

 

Compare the result of the two data sets, and the Operations used by the operator are usually used by the two.