What is Flashback Table in oracle 11g R2

In this tutorial i'll show you how Oracle Flashback Technology works and as well as inside how to use flashback version query.

In Oracle there are Seven Technology as given below.
   In the Flashback Technology, It include database related group of features that manage a state of your data in the database.

   This Technology works on the undo data so you can get all those transaction, query as well as data from undo segments thus, your can recovery your data which had been lost or damage as well as you can see the query which had been perform on a specific time or SCN. 

1. Flashback Query.
2. Flashback Transaction.
3. Flashback Transaction Query. 
4. Flashback Version Query.
5. Flashback Table.
6. Flashback Database.
7. Flashback Data Archive [ Total Recall ]. 

 Some few advantages given below,

• See the query had been perform.
• See the transaction information.
• See the past state data.
• You can perform rollback entire table without performing database recovery.
• If you delete or drop the table by mistake and you perform DDL or commit without knowing the previous transaction.  and so on...

Here i'll be show you 5^th  Flashback Version Query as below,

  This technology can recover your entire table to a specific time without having point in time recovery.
  The database online no required for shutdown or on mount mode.

•   This technology operation in-place table while database is running.
•   The Flashback table statement is executed as a single transaction, all table must be flashback.
•   In this operation data retrieve from undo tablespace.
•   When you perform flashback table before you must enable row movement.
•   If you have to do like this you must have privileges that is flashback table.
•   Flashback table provide a way for user to easily and quickly recover table from accidental modification.

You can enable row movement like,

 ALTER TABLE tbl_nm ENABLE ROW MOVEMENT;

For Example,

 ALTER TABLE employees ENABLE ROW MOVEMENT;
  
 FLASHBACK TABLE employees TO TIMESTAMP
    TO_TIMESTAMP ( '2016-03-15 2:00:00', 'YYYY-MM-DD HH24:MI;SS' );

 That's was a Flashback Table in oracle 11g r2.