************************************************************************************************
* Description: Knowledge of Oracle Flashback Technology, such as flashback query, restore point
* Date: 02:01 PM EST, 04/09/2020                         
************************************************************************************************

		 
<1> Oracle Flashback Technology:
     |
     |__ o. OFT is a group of "features" that can view past states of DB objects or to return objects to a previous state without point-in-time media recovery.
            Oracle Flashback features use the Automatic Undo Management (AUM) system to obtain metadata and historical data for transactions. 
            They rely on undo data, which are records of the effects of individual transactions.
	
	

	
	
<2> Oracle Flashback Feature Types:
     |
     |__ o. Application Development Features (Used by PL/SQL developer to restore data, when incidentally messed up data logically):
     |   |
     |   |__ o. Oracle Flashback Query
     |   |
     |   |__ o. Oracle Flashback Version Query
     |   |
     |   |__ o. Oracle Flashback Transaction Query
     |   |
     |   |__ o. DBMS_FLASHBACK Package
     |   |
     |   |__ o. Flashback Transaction
     |   |
     |   |__ o. Flashback Data Archive
     | 
     |  
     |__ o. Database Administration Features (Used by DBA to save the broken data logistic physically):
         |
         |__o. Oracle Flashback Table
         |
         |__o. Oracle Flashback Drop
         |
         |__o. Oracle Flashback Database (Restore Point)




<3> Example of data got deleted incidentally, and use Flashback Query to create a new table for recovery:
     |
     |__ SQL> CREATE TABLE sa.beneficiary_flashback_09052018 AS ( SELECT * FROM sa.beneficiary AS OF TIMESTAMP TO_TIMESTAMP('2018-09-05 17:08:00', 'YYYY-MM-DD HH24:MI:SS'));