How to Manage the Flashback Data Archive

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 […]
Read More ›

How to Use Temporal History in Oracle 12c to Track Changes Over the Lifetime of a Table

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 […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.