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.