Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
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.