Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Flashback data archive/total recall


Flashback data archive(FBDA) is a new concept introduced in 11g version of oracle.
This is mostly used in case of auditing.
FBDA is a new database object created along with the storage and retension policies.

FDA is a new tablespace designated.
Once we configure FDA, FBDA gets enabled and it picks the values from database buffer cache(DBC) updates to the tables that are created in a tablespace that was designated.
Insert is not going to record anything in the flashback archive tables.
In order to create FDA, user should have DBA role or Flashback data archive administrator role.
Related Posts Plugin for WordPress, Blogger...

Flag Counter