(Hemant K Chitale) In 11gR2, ALTER DATABASE FLASHBACK ON and OFF can be executed when the database is OPEN. Setting FLASHBACK OFF results in deletion of all Flashback Files.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help