recycle bin

-------recycle bin 存储删除的表及多他们的依赖对象
The Recycle Bin is a logical storage container for all dropped tables and their dependent objects;

select * from USER_RECYCLEBIN;

select * from DBA_RECYCLEBIN;
select object_name as recycle_name, original_name, object_name from recyclebin;
select * from "BIN$0ZVR8eDEQbK4s8G2Csf2kg==$0";
flashback table t1 to before drop rename to t2;
---------从recycle bin清除
purge table "BIN$0ZVR8eDEQbK4s8G2Csf2kg==$0";
purge tablespace t1 user user1;
purge recyclebin;
purge dba_recyclebin;
------------------the Recycle Bin 限制
Recycle bin exists for the tables only in non-SYSTEM, locally managed tablespaces
1.是local manager tablespace
2.DML.DDL不用于recycle bin
3.分区的索引组织的表不受recycle bin保护
4.Recycle Bin when the base table is dropped.
5.The Recycle Bin name of a table is required to query the table
6.reference constraint 不受Recycle bin 保护,必须rebuild
7. bitmap join indexes, referential integrity constraints (foreign key constraints), and