Hi Friends.

I am trying to explore into log miner concepts.

My database is 8.1.7 running on windows 2000.

1.Both the packages DBMS_LOGMNR & DBMS_LOGMNR_D WERE INSTALLED from SYS.

Grant execute on dbms_logmnr to system;
grant execute on dbms_logmnr_d to system;

2.UTL_FILE_DIR WAS SET IN init.ora

3. Stopped and restarted the services.

4. logged in as system/*****

5. when i am trying to create a dictionary like

begin
execute DBMS_LOGMNR_D.BUILD(
dictionary_filename => 'orcldict.ora',
dictionary_location => 'c:\tmp');
end;

I am getting an error message :

execute DBMS_LOGMNR_D.BUILD(
*
ERROR at line 2:
ORA-06550: line 2, column 9:
PLS-00103: Encountered the symbol "DBMS_LOGMNR_D" when expecting one of the
following:
:= . ( @ % ; immediate
The symbol ":=" was substituted for "DBMS_LOGMNR_D" to continue.

Any Help please!!!

Thanks
Ravi