LOG MINER PROBLEM

[fraze]

Hi,

I am having a problem running logminer on a test database we have. Running 8.1.6.2 on AIX.

I've created the dictionary file without a problem. I've then used dbms_logmnr.add_logfile(xxxxx) to feed in the archive logs I want to mine. No problem. The problem occurs when I try and run:

dbms_logmnr.start_logmnr('dictionary.ora');

I am getting the follwoing error:

SQL> execute dbms_logmnr.start_logmnr('dictionary.ora');
BEGIN dbms_logmnr.start_logmnr('dictionary.ora'); END;

*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 1


Anyone have any ideas?

Thanks in advance,

Fraze

[mnicoras]

H Fraze,
check view v$_logmnr_dictionary to see the status of your dictionary. try to set full path for the dictionary.ora when u try to start the action.

Marius