December 2002
Intermediate to advanced
928 pages
85h 29m
English
PROCEDURE DBMS_LOGMINER.ADD_LOGFILE
(logfilename IN VARCHAR2,
options IN BINARY_INTEGER DEFAULT ADDFILE);
Adds a file to the existing list of archive files to process.
PROCEDURE DBMS_LOGMINER.START_LOGMNR
(startSCN IN NUMBER DEFAULT 0,
endSCN IN NUMBER DEFAULT 0,
starttime IN DATE DEFAULT '01-JAN-1988',
endtime IN DATE DEFAULT '01-JAN-2988',
dict_file_name IN VARCHAR2 DEFAULT '',
options IN BINARY_INTEGER DEFAULT 0);
Starts a LogMiner session with either a starting and ending SCN or time. (If the SCNs are present, times are ignored.) dict_file_name is a flat file that contains a snapshot of the database catalog. For information on options, see the Oracle documentation.
PROCEDURE DBMS_LOGMINER.END_LOGMNR;
Ends a LogMiner session.
FUNCTION DBMS_LOGMINER.MINE_VALUE
(sql_redo_undo IN RAW,
column_name IN VARCHAR2 DEFAULT '')
RETURN VARCHAR2;
Extracts data about column_name from sql_redo_undo column in V$LOGMNR_CONTENTS and returns either NULL or non_NULL. New with Oracle9i.
FUNCTION DBMS_LOGMINER.COLUMN_PRESENT
(sql_redo_undo IN RAW,
column_name IN VARCHAR2 DEFAULT '')
RETURN NUMBER;
Extracts data about column_name from sql_redo_undo column in V$LOGMNR_CONTENTS and returns either 0, which indicates the column is not present, or 1, that it is. New with Oracle9i.