Home » RDBMS Server » Server Utilities » log miner
log miner [message #69897] Mon, 18 March 2002 18:29 Go to next message
krishna
Messages: 141
Registered: October 1998
Senior Member
I'm trying to set the log miner utility in my database. I ran the scripts
ORACLE_HOME/rdbms/admin/dbmslm.sql
and
$ORACLE_HOME/rdbms/admin/dbmslmd.sql successfully.
Now I added this to my init.ora file
UTIL_FILE_DIR=dictionary_location
I then bounced my database.
I then tried to run this.
EXECUTE DBMS_LOGMNR_D.BUILD(
dictionary_filename => 'l_dictionary.ora',
dictionary_location => d:oraclelogminer');
This is the error i got.

SQL> EXECUTE DBMS_LOGMNR_D.BUILD(
BEGIN DBMS_LOGMNR_D.BUILD(; END;

*
ERROR at line 1:
ORA-06550: line 1, column 27:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
( ) - + mod not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
table avg count current exists max min prior sql stddev sum
variance execute multiset the both leading trailing forall
year month DAY_ HOUR_ MINUTE_ second TIMEZONE_HOUR_
TIMEZONE_MINUTE_ time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string>
T

SQL> dictionary_filename => 'l_dictionary.ora',
SP2-0734: unknown command beginning "dictionary..." - rest of line ignored.

Can u help me out please?
Re: log miner [message #69898 is a reply to message #69897] Mon, 18 March 2002 18:41 Go to previous message
Carnage
Messages: 9
Registered: March 2002
Junior Member
check your code you hve missed " ' "
dictionary_filename => 'l_dictionary.ora',
dictionary_location => d:oraclelogminer');
*** " ' is required "
Previous Topic: foxpro data in oracle8
Next Topic: Importing Constraints...
Goto Forum:
  


Current Time: Fri Mar 29 01:22:05 CDT 2024