Using Streams and LOGMINER for auditing
271044Dec 4 2002 — edited Nov 22 2006I would like to find out if the following is achievable. The theory and manuals suggest that it may be.
I have a 9.2 database running MIS services.
I have a production 8.1.7 database running OLTP.
We need to implement an audit trail.
It is possible for 9i LOGMINER to access 8i redo logs (with restrictions).
ORACLE Streams uses LOGMINER to access log files.
Is it possible to get 9i Streams to use it's LOGMINER to access the 8i redo log files and stream it into our MIS. The MIS environment can then be reported upon.
This is an ideal solution as the logs contain transactional data and it will not affect production performance as TRIGGER based solutions would. It also involves a great deal less application development and testing.
Any input into this would be greatly appreciated.