Viewing Log miner fro TOra

[amolik]

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

[amolik]

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

[sandycrab]

Log miner is session specific also.
Sandy