oracle回收站Recyclebin对象删除机制(国外英语资料).docVIP

oracle回收站Recyclebin对象删除机制(国外英语资料) The Recyclebin object deletion mechanism, space release 1. What is the Recycle Bin In fact, the term Recycle Bin is simply a data dictionary table that holds the object of the drop. Therefore, you can query the information in the recycle bin via the following statement: Select * from recyclebin Unless you have a sysdba authority, each user can only see his or her own object. So, for users, its like everyone has their own recycle bin. Even if users have permission to delete other schema objects, they can only see their own objects in the recyclebin. The following drops do not put the relevant objects in the RecycleBin: Drop tablespace: it will remove all objects belonging to the tablespace in the RecycleBin Drop user: will remove all objects belonging to the user in the RecycleBin Drop cluster: all the member objects belonging to the cluster are removed from the RecycleBin Drop type: all the objects that depend on that type are removed from the RecycleBin The object in the RecycleBin will be renamed by the system automatically, in order to prevent a naming conflict. The name format: BIN $unique_id $version The unique_id is the only identifier for the object of 26 characters, and version is the version number of the object in the database. How to enable/disable the use of the RecycleBin By setting the initialization parameter, the recycle clebin, you can control whether the recycle stop function is enabled by default. The SQL alter system set recyclebin = off The system has changed. SQL alter system set recyclebin = on; The system has changed. SQL alter session set The session has changed. SQL alter session set recyclebin = on; The session has changed. How do you check the information in RecycleBin As mentioned earlier, the user can query the user for the drop to view the object belonging to the drop. SQL select object_name, object_type from dba_objects where object_name = RECYCLEBIN; OBJECT_NAME OBJECT_TYPE -- -- -- -- -- -- --