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

This article mainly introduces how to delete and restore tables and table data in the database, which has a certain reference value. Interested friends can refer to it. I hope you will gain a lot after reading this article. Let's take a look at it.

Flashback table TABLE_NAME to before drop; # drop table can then restore the table structure and data through the Recycle Bin through this command

Restore deleted tables: flashback table t_name to before drop; if the flashback table name is the same as the current table name, it needs to be renamed before it can be flashed back

Flashback table t_name to before drop rename to t_new

-after delete table data, restore data (undo space)

Confirm the delete time point and how many rows of delete data

Select count (*) from MPORTAL.SMS_BOOK_NUMBER as of timestamp to_date ('2017-09-19 13 hh34:mi:ss' 0015 0015 0015 009 0015)-- data at 13:00

Where employee_no not in (select employee_no from mportal.SMS_BOOK_NUMBER);-- and after deletion

Create table mportal.SMS_BOOK_NUMBER_20170919 as

Select * from mportal.SMS_BOOK_NUMBER as of timestamp to_timestamp ('2017-09-19 13VOG 001D hh34:mi:ss')

Where employee_no not in (select employee_no from mportal.SMS_BOOK_NUMBER)

Thank you for reading this article carefully. I hope the article "how to delete and restore tables and table data in the database" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you 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.