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'); |