Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to disable drop table flashback feature?

Re: How to disable drop table flashback feature?

From: Charles Schultz <sacrophyte_at_gmail.com>
Date: Wed, 15 Nov 2006 13:52:02 -0600
Message-ID: <7b8774110611151152l42ecc767na8ff5f4ecb76fbf2@mail.gmail.com>


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-l
Received on Wed Nov 15 2006 - 13:52:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US