Undo an update made on a column. [message #41262] |
Thu, 12 December 2002 07:27 |
Afagela
Messages: 9 Registered: December 2002
|
Junior Member |
|
|
Please help.
what is the proper syntax for undoing an update made to a column.
I've accidentally updated a column in a table and I want to put back the previous values in that column. Thanks.
|
|
|
Re: Undo an update made on a column. [message #41263 is a reply to message #41262] |
Thu, 12 December 2002 07:48 |
Rick Cale
Messages: 111 Registered: February 2002
|
Senior Member |
|
|
If you issued a commit then you have to do some type
of recovery. If not simply ROLLBACK.
If committed then we need more info.
Are you using logminer?
Are you using flashback query?
Do you have an export of table with old value?
Do you know what old value is and records to update? If so just issue update command
Rick
|
|
|