December 2002
Intermediate to advanced
928 pages
85h 29m
English
PROCEDURE DBMS_LOGMNR_D.BUILD
(dictionary_filename IN VARCHAR2,
dictionary_location IN VARCHAR2
[,options IN NUMBER]#);
Writes data dictionary information to dictionary_filename in dictionary_location, either as a flat file (options = STORE_IN_FLAT_FILE) or as redo logs (options = STORE_IN_REDO_LOGS). options are new with Oracle9i.
PROCEDURE DBMS_LOGMNR_D.SET_TABLESPACE
(tablespace IN VARCHAR2);
Re-creates LogMiner tables in a tablespace other than the default of SYS. New with Oracle9i.