Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Calls

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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page