CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_LOGMNR_D
Version 11.1
 
General
Source {ORACLE_HOME}/rdbms/admin/dbmslmd.sql
First Available 8i

Constants
Name Data Type Value
MARK_SAFE_MINE_POINT INTEGER 8
STORE_IN_FLAT_FILE INTEGER 1
STORE_IN_REDO_LOGS INTEGER 2

Dependencies
COL$ GV$LOGMNR_SESSION TAB$
DBMS_ASSERT IND$ TS$
DBMS_CAPTURE_ADM_INTERNAL INDPART$ USER$
DBMS_LOGMNR_INTERNAL OBJ$  

Exceptions
Number Description
ORA-01302 Dictionary build options are missing or incorrect.
ORA-01308 Initialization parameter UTL_FILE_DIR is not set
ORA-01336 Specified dictionary file cannot be opened
Security Model Execute privileged not granted
 
BUILD

Extracts the LogMiner data dictionary to either the redo log files or to a flat file. This information is saved in preparation for future analysis of redo log files using the LogMiner tool.
dbms_logmnr_d.build(
dictionary_filename IN VARCHAR2 DEFAULT '',
dictionary_location IN VARCHAR2 DEFAULT '',
options             IN NUMBER DEFAULT 0);
-- the database must be in archivelog mode with supplemental logging
-- enabled
 
SELECT log_mode, supplemental_log_data_min, supplemental_log_data_pk, supplemental_log_data_ui, supplemental_log_data_fk, supplemental_log_data_all, supplemental_log_data_pl
FROM v$database;

-- store in flat file
exec dbms_logmnr_d.build('mined_log_data.log', 'CTEMP', dbms_logmnr_d.store_in_flat_file);

-- store in redo log stream

exec dbms_logmnr_d.build(options=>dbms_logmnr_d.store_in_redo_logs);
 
SET_TABLESPACE
Move LogMiner tables from SYSAUX to an alternate tablespace dbms_logmnr_d.set_tablespace(new_tablespace IN VARCHAR2);
exec dbms_logmnr_d.set_tablespace('UWDATA');
 
Related Topics
Archive Logs
DBMS_LOGMNR
Logical Data Guard
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [206 users online]    © 2010 psoug.org