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: 1663
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: 21148
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: retrieve last row inserted
Next Topic: Kindly rewrite this code
Goto Forum:
  


Current Time: Tue Aug 22 04:24:02 CDT 2017

Total time taken to generate the page: 0.05341 seconds