How to Implement Temporal Validity in an Oracle Database
Jul 5,
2017
Overview of Temporal Validity Temporal Validity is also referred to as Valid Time Support. The objective is to allow tables to have one or more valid time dimensions. That is, the data is visible (“valid”) depending on its time-based validity. The valid time is determined by start and end dates or timestamps of a valid […]
How to Manage the Flashback Data Archive
Jun 15,
2017
In this post, we will continue with the theme of Information Lifecycle Management (ILM). Through ILM, I will be discussing how to successfully manage the Flashback Data Archive. Maintaining the Flashback Data Archives To add space to an existing archive: ALTER FLASHBACK ARCHIVE two_year_archive ADD TABLESPACE archive_two QUOTA 2G; To change the retention time: ALTER FLASHBACK ARCHIVE two_year_archive […]
How to Use Temporal History in Oracle 12c to Track Changes Over the Lifetime of a Table
May 24,
2017
In this posting, we are continuing with the theme of Information Lifecycle Management (ILM). As mentioned in an earlier posting, there usually comes a point during the lifecycle of the data when it is no longer being regularly accessed: May be obsolete and is eligible for purging Might be needed in the future but could […]
Introduction to Oracle Information Lifecycle Management (ILM)
Jan 18,
2017
What is Information Lifecycle Management (ILM)? Information Lifecycle Management (ILM) is the process of understanding, archiving and purging data. In short, it is a strategy for managing business data over its lifetime in order to reduce storage costs and improve data access within the database. Further, It is the practice of applying policies for the […]