Home » SQL & PL/SQL » SQL & PL/SQL » Updation in a table
Updation in a table [message #202841] Mon, 13 November 2006 00:52 Go to next message
sarfraz_attari
Messages: 123
Registered: July 2005
Senior Member
Dear all

I Updated few rows in a table by mistake and commit those rows,is there any table in database which shows which rows we modified during particular time.

thanks

Sarfraz
Re: Updation in a table [message #202844 is a reply to message #202841] Mon, 13 November 2006 01:03 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Not by default no.
You could have tried a flashback query (look in the docs if you don't know them), but it will be too late for that now.
Re: Updation in a table [message #203070 is a reply to message #202841] Mon, 13 November 2006 15:34 Go to previous messageGo to next message
Bill B
Messages: 1482
Registered: December 2004
Senior Member
You can also use logminer to look at the before values of the rows. See the following link.

http://www.oracle.com/technology/oramag/oracle/05-jul/o45dba.html
Re: Updation in a table [message #203139 is a reply to message #203070] Tue, 14 November 2006 01:13 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Also, if your UPDATE was the only thing that changed recently (i.e. since the last backup (or perhaps export)), you could try to restore this table to state before update.
Previous Topic: Duplicate Account Check Process
Next Topic: Column Output in a Single Line with , seperated
Goto Forum:
  


Current Time: Sat Dec 03 15:49:54 CST 2016

Total time taken to generate the page: 0.08324 seconds