-
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
-
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
