sam15
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
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.
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.
ASKER