-
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
-
if you searched for the error on metalink you would fine the first hit probably explains your problem
-
Yes davey23uk
in that note version having problem is given as 8.1 and
fix as
Upgrade to Oracle 9.0.1 or apply the 8.1.7.2 patchset
. but i am already on 9.0.1.
so i am confused....
Rgds
Parag
-
Hi,
you have to upgrade to 9iR2, it's a well known bug according to metalink.
Regards.
Anyone can hold the helm when the sea is calm.
-
ya was looking at list of 9i bugs there are lot many in log-miner section...
Thanks anyways...
Rgds
Parag
-
But you know you can always install an Oracle 9iR2 on a new box and use its logminer to extract your queries using your 9.0.1 redologs.
Anyone can hold the helm when the sea is calm.
-
Wow thanks i never gave thought to this thing...
thanks it looks better option...
Rgds
Parag
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|