How to disable drop table flashback feature?

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Wed, 15 Nov 2006 14:46:38 -0500
Message-ID: <D6424CD4C8A3C044BBC49877ED51C51801DBB19D@ex2003.metratech.com>

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

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 Received on Wed Nov 15 2006 - 13:46:38 CST