| Log file Information [message #51728] |
Mon, 10 June 2002 22:27  |
B. Jaya Shankar
Messages: 1
Registered: June 2002
|
Junior Member |
|
|
As an Oracle client I insert, update, delete and rollback records from and into various tables through my application. Now I wish to see all the deleted record and all the newly inserted records for the various tables? where does Oracle store this detail?
I'm not looking at a single user in particular.
Which log file will give me this information?
How to get the information about each record that has been newly inserted or recently deleted and also the tables that these records affect.
Can this information be viewed from the client end as well?
|
|
|
|
| Re: Log file Information [message #51730 is a reply to message #51728] |
Tue, 11 June 2002 00:50  |
Alex Shenfield
Messages: 15
Registered: May 2002
|
Junior Member |
|
|
Hi,
Oracle does not give you an easy way to just look at the log files as standard.
You have two options as i see it .
1) Look at setting up auditing
2) Look at log minor
For a non Oracle solution there are tools too look at the log files.
|
|
|
|
| Re: Log file Information [message #51746 is a reply to message #51728] |
Tue, 11 June 2002 15:16 |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
You need to setup Log Miner and then load the archived or redo logs for the period of time you need this information. It should show you the DML commands as well as the undo and redo statements. Check the Oracle docs PL/SQL packages - DBMS_LOGMNR_D and DBMS_LOGMNR.
Archived logs have time stamps so get those which you need.
Hope that helps,
clio_usa
OCP DBA 8/8i/9i
Visit our web site [url=http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi]Click Here
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
