Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

download oracle logminer

Posted on 2006-11-30
13
Medium Priority
?
910 Views
Last Modified: 2008-02-01
Pl write the link from where i can download the oracle logminer for oracle 8 or 9 ...
i want to find out when was an oracle 8 table last updated....
thanks...
0
Comment
Question by:at999
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
13 Comments
 

Author Comment

by:at999
ID: 18048110
is there any dataminer for oracle 9 /oracle 8 still available?
0
 
LVL 11

Expert Comment

by:mohammadzahid
ID: 18048732
Oracle logminer is comes with 9i. Logmnr is invoked by START_LOGMNR procedure.

here is some detailed information and setup on Logmnr:

http://www.oracle-base.com/articles/8i/LogMiner.php
0
 

Author Comment

by:at999
ID: 18055326
does TOAD have these data mining options - to check when was table last updated(Without putting in triggers etc)
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 11

Expert Comment

by:mohammadzahid
ID: 18055374
Yes newer versions of TOAD have logminer (ver: 8.0, 9.0)  but I suggest you run logminer from sqlplus as that will give you more in-depth understanding. Logminer concept is very easy to learn and understand. Let me know if you need any documentation or steps on running logminer to dectect SCN# of a transaction.

0
 

Author Comment

by:at999
ID: 18056024
if i use the logminer that u suggest, do i have to add triggers to the existing tables? or do i have ot change structure of tables?
thanks
0
 

Author Comment

by:at999
ID: 18056032
if i use the logminer -in SQLPLUS  that u suggest, do i have to add triggers to the existing tables? or do i have ot change structure of tables?
0
 
LVL 11

Expert Comment

by:mohammadzahid
ID: 18056066
no. you don't need to add table or make any changes to the tables. LOGMINER primary function is to detect SCN# for a transaction that it reads from current, INACVTIVE, ACTIVE as well as redo log files. Datafiles are not used in logminer.

Any file with extension .log, .arc (Archive log files) . Logminer is a very smart. If SCN# is current it won't let you add new data to logminer dictionary and terminate itself. So, there is nothing to worry about.

What type of recovery are you running? CANCEL, SEQUENCE, TIME BASED or SCN# based? Let me know.
0
 

Author Comment

by:at999
ID: 18056719
how do i know what kind of recovery is set up on the database instance?
i am not the dba.. i dont know the system password
0
 
LVL 11

Expert Comment

by:mohammadzahid
ID: 18056845
Then you will not be able to use logmnr. In order to compile logmnr procedure you need to connect as user "SYS" . Backup and recovery is typicall a job of a DBA. If you are not a DBA then please contact your DBA, explain the problem and give him/her as much information you can so that he/she can recovery your lost transaction or restore database. DBA will know which recovery option to use, I am sure he/she have recovered database at some point in there career.




0
 

Author Comment

by:at999
ID: 18057236
i have got the system pwd, now pl guide me how to use the default built in logminer with oracle 8
0
 
LVL 11

Accepted Solution

by:
mohammadzahid earned 1000 total points
ID: 18057257
Here are the detailed steps on using Logmnr. I am not sure if these apply to version 8  as I have never used logmnr in version8 but I can definately help you in getting started with Logmnr.

http://www.cs.umbc.edu/help/oracle8/server.815/a68001/dbms_log.htm
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question