• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • Last Modified:

FlasshbackDataArchive_Auditinng.

a couple of questions on flashback data archive in 11g

1) Is this license product or it is part of the datbas fetaure.

2) Can this be used for long-term data auditing capture to replace all the trigger code and SHADOW tables that we had to do in 9i. From my understanding this is very easy to use and there is not need to write code with no performance impacts, etc.

Basically I want to track DML (updates and deletes) on some tables for the entire ROW and be able to see he ful history changes for a row if needed.
0
sam15
Asked:
sam15
  • 2
1 Solution
 
sam15Author Commented:
Forgot to say i think this product is also called oracle total recall.
0
 
Devinder Singh VirdiCommented:
I think its free, but you can clarify by chat session with oracle using the following link
http://www.oracle.com/us/products/database/index.html?ssSourceSiteId=otnen

I found the following link for archiving http://example.oradba.net/security/flada/flada.htm
0
 
sam15Author Commented:
It is an otpion to the database at extra cost

http://download.oracle.com/docs/cd/E11882_01/license.112/e10594/toc.htm

It seems no one from the experts here used it for auditing data or familiar with it.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now