-
log miner
Hi all,
I'm currently testing the log miner.
The things to do are:
1.) Edit the init.ora and specify the log location.
utl_file_dir = c:\oracle\logs
2.) Login to system/passwd
sql> EXECUTE dbms_logmnr_d.build(dictionary_filename =>'dictionary.ora',dictionary_location => 'c:\oracle\logs');
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_LOGMNR_D.BUILD' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
sql> EXECUTE DBMS_LOGMNR_D.BUILD('dictionary.ora','c:\oracle\logs', OPTIONS => DBMS_LOGMNR_D.STORE_IN_FLAT_FILE);
ERROR at line 1:
ORA-06550: line 1, column 73:
PLS-00201: identifier 'DBMS_LOGMNR_D.STORE_IN_FLAT_FILE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
What missing in my command?
Thanks,
-
-
You did run the dbmslmd.sql before setting all that up right?
See for more...http://technet.oracle.com/docs/produ...redo.htm#12680
Last edited by Tarry; 05-16-2003 at 04:30 AM.
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
-
Thanks Pando, and sorry, I forgot.
I searched "logminer" and got lots of previous post about it.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|