-
Hi
This is for you if you are using Tora . I have started the logminer from sql prompt and now wanted to view the details of V$LOGMNR_CONTENTS from TORA. I connected to SYS using sysdba privileges from TORA. But When I say select * from v$logmnr_contents then it does not get executed.
It throws the following error.
ORA-01306 - dbms_logmnr.start_logmnr() must be invoked.
Why this is happening when I have already started it
Amol
-
Hey it worked
I have to start log miner in the Tora as well . I never knew that the Log Miner are instance specific. In the SQL window of Tora you have run the package dbms_logmnr package in Begin .. End block.
Amol
-
Log miner is session specific also.
Sandy