Use of logminer

There are many online users about this, such

 

Http://qinry.blog.163.com/blog/static/9383504720118810658115/

Or http://hi.baidu.com/52hack/item/2e31f1f65a0b6848922af239.

 

Supplement the problems you encounter during use.

 

 

Problem:
Run 'tionary in dbms_logmnr_d.build ('dictionary. ora ', 'd: \ dir'); end;' when the statement is executed, the following message is displayed:
ORA-01308: initialization parameter utl_file_dir not set
Premise: the utl_file_dir directory has been created using the create directory statement at D: \ dir.
SQL> show parameter utl_file_dir;
 
Name type value
-----------------------------------------------------------------------------
Utl_file_dir string

Cause analysis: The utl_file_dir parameter is different from the created utl_file_dir directory.
Solution:
1) alter system set utl_file_dir = 'd: \ dir 'scope = spfile;
2) restart the database
View the path of the utl_file_dir parameter again:
SQL> show parameter utl_file_dir;
 
Name type value
-----------------------------------------------------------------------------
Utl_file_dir string D: \ dir
Note: you cannot use scope = both to modify this parameter dynamically. In this mode, you can modify both the spfile and the current settings.