Oracle9i Enhancements
Oracle9i Log Miner now supports objects with chained and migrated rows, and data types such as longs, lobs, and even CREATE TABLE and CREATE INDEX commands.
The Oracle8i version used ROWID in the REDO and UNDO SQL. This made it rather difficult to use this script on other Oracle databases. The Oracle9i version uses primary key values instead of ROWID. This should make it easier to apply a desired transaction to multiple Oracle databases. The Oracle9i version of V$LOGMNR_CONTENTS also includes 2 new columns: redo_value and undo_value. This has a number of uses including seeing exactly what the user changed.
Oracle9i Log Miner has added 4 new PL/SQL functions to the DBMS_LOGMNR package: COLUMN_PRESENT, MINE_VARCHAR, MINE_NUMBER ...
Get Oracle9i™ Development by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
