• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 975
  • Last Modified:

download oracle logminer

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
at999
Asked:
at999
  • 6
  • 5
1 Solution
 
at999Author Commented:
is there any dataminer for oracle 9 /oracle 8 still available?
0
 
mohammadzahidCommented:
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
 
at999Author Commented:
does TOAD have these data mining options - to check when was table last updated(Without putting in triggers etc)
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
mohammadzahidCommented:
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
 
at999Author Commented:
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
 
at999Author Commented:
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
 
mohammadzahidCommented:
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
 
at999Author Commented:
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
 
mohammadzahidCommented:
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
 
at999Author Commented:
i have got the system pwd, now pl guide me how to use the default built in logminer with oracle 8
0
 
mohammadzahidCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now