For help, the table data from-CodePudding

I use this app # CSDN# found have technical content of the blog and friends to seek common to "oracle data accidentally delete data recovery", looked together https://blog.csdn.net/qiuzhi__ke/article/details/78740943
According to the operation, this article took 133 minutes for the first query, and now also in turned around, is not to come out the result

CodePudding user response:

How to delete, delete to delete the data, truncate truncate table, delete the table structure or drop?

CodePudding user response:

With flashback query find these data first

SELECT * FROM tab_name
AS OF the TIMESTAMP TO_TIMESTAMP (' 2019-09-08 12:00:00 ', 'YYYY - - DD HH: MM MI: SS')
The WHERE... ;
Because the flashback query and query can have the purpose of the where clause for you to delete the data, can save a lot of time, check the data if you delete data,
Flash and then create a temporary table to query the data inserted into the new table
The create table tab_tmp as
SELECT * FROM tab_name
AS OF the TIMESTAMP TO_TIMESTAMP (' 2019-09-08 12:00:00 ', 'YYYY - - DD HH: MM MI: SS')
The WHERE... ;
Such data retrieved, the data in the table to insert the original ok

CodePudding user response:

refer to the second floor js14982 response:

with flashback query find these data first

SELECT * FROM tab_name
AS OF the TIMESTAMP TO_TIMESTAMP (' 2019-09-08 12:00:00 ', 'YYYY - - DD HH: MM MI: SS')
The WHERE... ;
Because the flashback query and query can have the purpose of the where clause for you to delete the data, can save a lot of time, check the data if you delete data,
Flash and then create a temporary table to query the data inserted into the new table
The create table tab_tmp as
SELECT * FROM tab_name
AS OF the TIMESTAMP TO_TIMESTAMP (' 2019-09-08 12:00:00 ', 'YYYY - - DD HH: MM MI: SS')
The WHERE... ;
Data back to do so, it is ok that the data in the table to insert the original

thank you, I was writing, could you tell me more than 40 ten thousand how long it will take to good

CodePudding user response:

Speed of the server itself performance configuration,
It is commonly ctas created to the temporary table, then put back to the table,