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
dictionary_filename => 'orcldict.ora',
dictionary_location => 'c:\tmp');
I am getting an error message :
ERROR at line 2:
ORA-06550: line 2, column 9:
PLS-00103: Encountered the symbol "DBMS_LOGMNR_D" when expecting one of the
:= . ( @ % ; immediate
The symbol ":=" was substituted for "DBMS_LOGMNR_D" to continue.
Any Help please!!!