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