Oracle 12c - Temporal Validity


Temporal validity feature allows you to add a valid time dimension to the table data by specifiying the start and end datetimes of the period for which the data should be valid and visible.
Flashback query clauses ASOF, VERSIONS can be used to query the data valid for a specified period of time. You can also control the data visibility at the session level by using the DBMS_FLASHBACK_ARCHIVE.enable_at_valid_time procedure.

Oracle 12c - In-Database Archiving


In-Database Archiving, one of the many exciting 12c features, allows you to selectively archive the data that is no longer needed for the application, yet you can keep it online along with other active data within the same database for the audit compliance.  
In order to access the archived data, all you need to do is just change the visibility setting for the session. This will greatly save you from all the tedious process of the tape backup restore and loading the data back to the database.
Even though the archived data is not displayed by default, it is still residing within the same table and will still be validated for all the constraint rules similar to the active data. Also, it is recommended to compress the archived data to prevent any application query and backup performance issues.
Here is a small demo for this feature.

Copyright ©2018 Rajkiran Ghanta (