Manage

How to get history of modified data from Oracle databases

An Oracle user asks how to get the history of data modified from an Oracle database.

Brian Peasland

Published: 14 May 2008

How can you get the history of data modified from an Oracle database?

There are a few options at your disposal. After the fact, you can mine your archived redo logs using Oracle's Log Miner utility. This presumes you have the archived redo logs available. For more information on how to use Log Miner, refer to the following documentation:

Using LogMiner to Analyze Redo Log Files

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

Before the fact, you can set up auditing to record changes. With auditing, you can record actions in a database table as they happen and then query the table any time in the future. For more information on auditing, please refer to the following documentation:

Database Auditing: Security Considerations

Dig Deeper on Oracle database administration

All
Get Started
Evaluate
Manage
Problem Solve

Oracle NoSQL Database

Related Q&A from Brian Peasland

Managing Oracle connections from third-party apps

Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading

Perfect the Oracle RMAN duplicate 10g command

One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading

Managing SQL parent table-child table relations

Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

Managing unstructured data is crucial to enterprises' AI goals

Unstructured data makes up a huge portion of most businesses' data volume. But, with data-hungry AI systems coming online, making...

ScyllaDB set to improve NoSQL database performance

ScyllaDB has been helpful for big organizations such as Comcast, which was able to trim from nearly 1,000 database nodes to 78 ...

Translytical data platforms provide options to unify databases

Forrester identifies top vendors in the translytical database category and common elements that help make the unified database ...

SearchBusinessAnalytics

Salesforce acquisition of Tableau details emerge as CEOs speak

The Salesforce and Tableau CEOs appeared together for the first time at Tableau Conference 2019, five months after the analytics ...

Tableau analytics platform gets AI, data management upgrades

Augmented intelligence, improved data management capabilities and a tool to monitor KPIs are at the core of improvements unveiled...

Tableau partners with AWS to release Modern Cloud Analytics

Tableau revealed an expanded partnership with AWS on Tuesday to help the vendor's on-premises users migrate their analytics ...

SearchSAP

SAP partner program strives for long-term relationship with customers

In this Q&A, SAP chief partner officer Karl Fahrbach discusses why the company has evolved its partner program to reward customer...

SMBs focus on future with S/4HANA and SAP intelligent enterprise

Medical device startup Enable Injections is small now but intends to be big soon, so it's implementing SAP S/4HANA in phases to ...

A primer on Employee Central Service Center

SAP has created Employee Central Service Center to simplify how HR issues get resolved. Here's a look at who it's for, how it ...

SearchSQLServer

SQL Server database design best practices and tips for DBAs

Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered ...

SQL Server in Azure database choices and what they offer users

SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options ...

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

TheServerSide.com

A Jenkins tutorial for beginners with examples

If you're ready to try Jenkins, this quick start tutorial lays out the specific steps you'll need to take to download and install...

Why AI application development isn't as far away as you think

The distance between application development and AI development continues to narrow. Here's how to integrate AI into your app dev...

AWS ups Java support, joins Java Community Process

By joining the Java Community Process, AWS will have its say over how the Java language and platform will evolve to meet the ...

SearchDataCenter

Microsoft quantum development turns toward hardware

Microsoft revealed plans to jump into the quantum hardware business with a chip capable of running quantum software.

Top 5 options for Linux certifications

Are you ready to expand your Linux knowledge? Here's a look at the latest courses, training content and exams available from ...

New hardware, use cases shape server benchmarking needs

Advancements in server hardware help admins address the latest data-intensive use cases. But this brings questions about the ...

SearchContentManagement

Adobe Sign introduces updates targeting mobile device users

The updates include a new home screen and a page for users to track the signing process, the ability to zoom and navigation ...

Acquia, Drupal founder Dries Buytaert on open source, Vista, CDPs

Acquia and Drupal founder Dries Buytaert discusses his company's move into marketing automation, CDPs and what's next after Vista...

How Kaizala for Office 365 competes with ECM platforms

Kaizala is a solid option for a mobile messaging service, but organizations should consider its effect on enterprise content ...

SearchHRSoftware

Kronos introduces its latest time clock, Kronos InTouch DX

The newly launched time clock integrates with Workforce Dimensions, Kronos' workforce management suite, providing real-time ...

HRIS department an essential bridge between HR, IT

Emerson Electric's VP of HRIS explains why it's important to have a team that can translate HR needs into the black and white of ...

ADP DataCloud makes its data easier to use

ADP DataCloud has an upgrade that includes what it calls 'mashup' capabilities. This will make it easier for customers to overlay...

Dig Deeper on Oracle database administration

Related Q&A from Brian Peasland

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.