ZZW Original _oracle Recycle Bin related operation knowledge

1. Query the Recycle Bin status statement

SELECT * from User_recyclebin ORDER BY droptime Desc

2. Restore the Recycle Bin

FLASHBACK TABLE <<Dropped_Table_Name>> to before DROP RENAME to <<New_Table_Name>>;

Note: The rename here is to rename the deleted object, which is an optional command.

Note the point:

1, about the dropped_table_name is original_name or bin$ so the beginning of the object_name?

Actually all can, but there is a little important difference, if the same table name is deleted more than one table, when the use of original_name, is to recover the last deleted table, so want to accurately restore a deleted table, Dropped_table_name must use object_name. For example, if you delete the Bdc_verdion table more than once and want to restore the 2nd deleted bdc_verdion table, you must use FLASHBACK table "Bin$s9tqgocix7nguweaah/psq==$0" to before drop RENAME to recover. Because object_name is unique (a glance to the recently deleted object_name seems to be the same, wide eyes look closely, in fact there is a letter difference)

2, note that because object_name contains special characters, you must enclose them in double quotation marks, otherwise the table name will be invalid.

ZZW Original _oracle Recycle Bin related operation knowledge