Oracle® Database Reference 11g Release 2 (11.2) E40402-08 |
|
|
PDF · Mobi · ePub |
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.