Logminer giving error when using where clause
Hi,
I was trying to test logminer. So i created a table added some values.commit; Then deleted some and commit. After that i went in following way
1) Cretaed dictionary file
2)Added logfile to Logminer.
3) started logminer to use all the logs .
EXECUTE Dbms_Logmnr.Start_Logmnr( -
dictfilename =>'d:\oracle\oradata\parag.ora');
then i queried v$logmnr_contents with
select sql_redo,sql_undo from v$logmnr_contents where seg_name = 'LGMNRTEST1';
for first time i got 03113-End of file on comminication channel.
after that i again started new session and went through all the above steps but now it is giving error like :-
SQL> select * from v$logmnr_contents where seg_name = 'LGMNRTEST1';
SP2-0642: SQL*Plus internal error state 2133, context 0:0:0
Unsafe to proceed
if i do select * from v$logmnr_contents it gives me no error. Only when i am putting where clause i am getting this error...
What am i doing wrong....
Rgds
Parag