log miner [message #69897] |
Mon, 18 March 2002 18:29 |
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 |
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 "
|
|
|