Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to disable drop table flashback feature?
flashback and drop table are two completely different things so having
flashback off wont affect drop tables
anyway, this is what you want if on 10gR2
ALTER SYSTEM SET recyclebin = OFF;
its undocumented in 10gR1.
Also it doent affect space consumption as it is re-used if needed, so you dont need to change anything
On 15/11/06, Harvinder Singh <Harvinder.Singh_at_metratech.com> wrote:
>
>
> Now when we drop table, oracle puts them in recycle bin and we have to
> use purge syntax of drop statement, Is there any way we can disable this
> feature also so that oracle never put any objects in recycle folder and
> we don't need to modify all our currect drop statements?
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 15 2006 - 13:53:08 CST
![]() |
![]() |