| General Information |
| Subprograms |
|
| 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 |
Owned by SYS with no granted privileges |
| |
| 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); |
Code from /rdbms/admin/utllmup.sql
Reformatted for clarity only |
DECLARE
rowcnt NUMBER;
BEGIN
SELECT COUNT(1)
INTO rowcnt
FROM sys.v$database v
WHERE v.log_mode = 'ARCHIVELOG'
AND v.supplemental_log_data_min != 'NO';
IF 0 != rowcnt THEN
dbms_logmnr_d.build(options=>4);
END IF;
END;
/ |
| |
| 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'); |
