[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Reconstruct DML statements from Oracle sqlarea

Posted on 2012-03-12
1
Medium Priority
?
428 Views
Last Modified: 2012-06-22
How can I reconstruct a complete DML statements (any insert/update/delete) that has occured in an oracle enviroment over a given time period in the sequence that those statements occured?
0
Comment
Question by:ITDeptAtPCS
1 Comment
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 1500 total points
ID: 37712606
I can read this question two ways:
1- already existing transactions on a current database:
    If you do not have auditing turned on, check out LogMiner.
http://docs.oracle.com/cd/B19306_01/server.102/b14215/logminer.htm

2- You wish to reproduce workload and do not have existing transactions.  Check out Real Application Testing (RAT):
http://www.oracle.com/us/products/database/options/real-application-testing/overview/index.html
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

829 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