Property | Description |
---|---|
Parameter type | Boolean |
Syntax | RECYCLEBIN = [ ON | OFF ] |
Default value | ON |
Modifiable | ALTER SESSION , ALTER SYSTEM |
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
, dropped tables go into the recycle bin and can be recovered.