Re: How to disable drop table flashback feature?

recyclebin = OFF

On 11/15/06, Harvinder Singh <Harvinder.Singh@xxxxxxxxxxxxx> 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

Other related posts: