Dont get confused with Arnold Picture and Movie call "Total Recall"
We going to discuss different total recall i.e. Oracle database 11g new features :- Total Recall
A Flashback Data Archive provides the ability to track and store all transactional changes to a table over its lifetime. It is no longer necessary to build this intelligence into your application. A Flashback Data Archive is useful for compliance with record stage policies and audit reports.
With Total Recall’s Flashback Data Archive technology, managing historical data should no longer be a painful task. It provides an extremely secure, efficient, easy to use and application transparent solution for managing historical data as well as a centralized, secure query-able historical data store that makes the most efficient use of all your resources – be it CPU, Storage or administrator time, and it enables and reduces your cost of compliance.
1) Creating a Flashback Data Archive
2) Specifying the Default Flashback Data Archive
3) Enabling and Disabling Flashback Data Archive
4) DDL Statements Not Allowed on Tables Enabled for Flashback Data Archive
5) Viewing Flashback Data Archive Data
CREATE FLASHBACK ARCHIVE DEFAULT flatest TABLESPACE RAG_tbs1 -When history data from emp exceeds the age of 1 years,
- Using Flashback Data Archive to Access Historical Data SELECT emp_id, sal FROM emp AS OF Coming soon ...all details about Total Recall |
Restriction
Following DDL statements on a table enabled for Flashback
Data Archive causes error ORA-55610:
- ALTER TABLE statement that does any of the following:
- Drops, renames, or modifies a column
- Performs partition or subpartition operations
- Converts a LONG column to a LOB column
- Includes an UPGRADE TABLE clause, with or without an INCLUDING DATA clause
- DROP TABLE statement
- RENAME TABLE statement
- TRUNCATE TABLE statement
Refrence
Posts
No comments:
Post a Comment