Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to disable drop table flashback feature?
recyclebin = OFF
On 11/15/06, Harvinder Singh <Harvinder.Singh_at_metratech.com> wrote:
>
>
> Hi,
>
> We have flashback_on as NO in the instance and don't see any flashback
> logs generated.
> SQL> select flashback_on from v$database;
> FLASHBACK_ON
> ------------------
> NO
>
> 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?
>
> Thanks
> --Harvinder
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Charles Schultz -- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 15 2006 - 13:52:02 CST