You may get ORA-38706: Cannot turn on FLASHBACK DATABASE logging while enabling flashback

Problem:

 

solution:

 

  1. Put database in archivelog mode , if not

            How to enable archivelog mode 

 

Set  db_recovery_file_dest and  db_recovery_file_dest_size parameter.

 

Now enable flashback

 

SEE  ALSO:

how-to-enable-and-disable-flashback-in-oracle-database

How to use flashback queries