Viewing Log miner fro TOra
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Viewing Log miner fro TOra

  1. #1
    Join Date
    Dec 2000
    Posts
    255
    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

  2. #2
    Join Date
    Dec 2000
    Posts
    255
    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

  3. #3
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    Log miner is session specific also.
    Sandy
    "Greatest Rewards come only with Greatest Commitments!"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width