Extracting Source Dictionary Data
1 flat file
2 redo log files
3 online catalog

LogMiner Restrictions
LONG and LOB
ADTs
Collections
Object Refs
IOTs

LogMiner Views
V$LOGMNR_CONTENTS
V$LOGMNR_DICTIONARY
V$LOGMNR_LOGS
V$LOGMNR_PARAMS

PL/SQL Packages:
DBMS_LOGMNR
DBMS_LOGMNR_D

Starting LogMiner
1 DBMS_LOGMNR.START_LOGMNR
2 startTime and endTime
3 startScn and endScn
4 Options

Options
1 COMMITTED_DATA_ONLY
2 SKIP_CORRUPTION
3 DDL_DICT_TRACKING
4 NO_DICT_RESET_ONSELECT

Example

@c:\oracle\oracle9i\rdbms\admin\dbmslm.sql
@c:\oracle\oracle9i\rdbms\admin\dbmslmd.sql
@c:\oracle\oracle9i\rdbms\admin\dbmslms.sql

EXECUTE DBMS_LOGMNR.START_LOGMNR(DICTFILENAME =>'/oracle/database/dictionary.ora');
EXECUTE DBMS_LOGMNR.START_LOGMNR(OPTIONS => DICT_FROM_ONLINE_CATALOG);
EXECUTE DBMS_LOGMNR.START_LOGMNR('DICT_FROM_ONLINE_CATALOG');

1. execute DBMS_LOGMNR.START_LOGMNR(OPTIONS => DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_DICT_RESET_ONSELECT + DBMS_LOGMNR.DICT_FROM_REDO_LOGS);

2. SELECT sql_redo FROM SYS.V$LOGMNR_CONTENTS;

3. SQL_REDO
   ----------------------------------------------------------------------------

create table scott.customer(name varchar2(32), phone_day varchar2(20), phone_evening varchar2(20));

insert into "SCOTT"."CUSTOMER"("NAME","PHONE_DAY","PHONE_EVENING") values (’Nadine Gordimer’,’847-123-1234’,’415-123-1234’);

insert into "SCOTT"."CUSTOMER"("NAME","PHONE_DAY","PHONE_EVENING") values (’Saul Bellow’,’847-123-1234’,’415-123-1234’);

commit;

alter table scott.customer drop (phone_evening);

insert into "SCOTT"."CUSTOMER"("NAME","PHONE_DAY") values (’Gabriel Garcia Marquez’,’044-1270-123-1234’);

commit;