RE: Log Miner

RE: Log Miner

 

  

I don't see an answer to your question.
I'm running 8.1.7.4 on Solaris.

I have done some limited LOGMINER stuff.

These are the steps I use:
(1) run=> sys.dbms_logmnr_d.BUILD(<your stuff>)
(2) run=> sys.dbms_logmnr_d.ADD_LOGFILE( <your stuff> )
(3) run=> sys.dbms_logmnr_d.START_LOGMNR ( <your stuff)
(4) select * from v$logmnr_contents where <what you want>
(5) run=> sys.dbms_logmnr_d.END_LOGMNR

Hope this helps

Jeff

-----Original Message-----
From: oracledba-return-134339-JEFFERY.L.SCHRENK=saic.[Email address protected]
[mailto:oracledba-return-134339-JEFFERY.L.SCHRENK=saic.[Email address protected]
On Behalf Of Aruna
Sent: Wednesday, November 01, 2006 10:54 PM
To: LazyDBA Discussion
Subject: Log Miner



Hi,

I am trying to accomplish the task in which I am using log miner. I am
executing the following on sqlplus prompt.

begin
dbms_logmnr.start_logmnr
(options =>
dbms_logmnr.dict_from_online_catalog);
end ;
/

But i am getting the errors which says
PLS-00302: component 'DICT_FROM_ONLINE' must be declared

Can you advice, why this was occurring?






---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


Oracle LazyDBA home page