1 , Extracting the LogMiner Dictionary to a Flat File

Need to configure utl_file_dir Parameter , This Parameter is a Static Parameter , so the database restart is required.

1 , alter system set utl_file_dir ="c:" scope=spfile;

2 , restart the database.

3 , execute dbms_logmnr_d.build('dictionary.ora',-

'c:',- 注：此目录必须与 utl_file_dir 保持一致

DBMS_LOGMNR_D.STORE_IN_FLAT_FILE);

我的 dictionary.ora 生成出来的大小为： 31M

[@more@]

ITPub博客

Oracle 10G Logminer