RECYCLEBIN

Property	Description
Parameter type	String
Syntax	RECYCLEBIN = { on | off }
Default value	on
Modifiable	ALTER SESSION, ALTER SYSTEM ... DEFERRED
Basic	No

RECYCLEBIN is used to control whether the Flashback Drop capability is turned on or off. If the parameter is set to off, then dropped tables do not go into the recycle bin. If this parameter is set to on, then dropped tables go into the recycle bin and can be recovered.

Note:

1. The Recycle Bin is a virtual container where all dropped objects reside. Underneath the covers, the objects are occupying the same space as when they were created. If table EMP was created in the USERS tablespace, the dropped table EMP remains in the USERS tablespace. Dropped tables and any associated objects such as indexes, constraints, nested tables, and other dependant objects are not moved, they are simply renamed with a prefix of BIN$$. You can continue to access the data in a
dropped table or even use Flashback Query against it. Each user has the same rights and privileges on Recycle Bin objects before it was dropped. You can view your dropped tables by querying the new RECYCLEBIN view. Objects in the Recycle Bin will remain in the database until the owner of the dropped objects decides to permanently remove them using the new PURGE command. The Recycle Bin objects are counted against a user's quota. But Flashback Drop is a non-intrusive feature.

2. Objects in the Recycle Bin will be automatically purged by the space reclamation process if

· A user creates a new table or adds data that causes their quota to be exceeded.

· The tablespace needs to extend its file size to accommodate create/insert operations.

3. There is no issues with DROPping the table, behaviour wise. It is the same as in 8i / 9i. The space is not released immediately and is accounted for within the same tablespace / schema after the drop.

4. When we drop a tablespace or a user there is NO recycling of the objects.

5. Recyclebin does not work for SYS objects

6. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = 'RECYCLEBIN';

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE		ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
recyclebin	on	TRUE	TRUE	IMMEDIATE	TRUE		FALSE	recyclebin processing

Oracle initializatoin parameters