Re: Bad Field Update

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Sun, 10 Aug 2003 19:10:57 +0300
Message-ID: <3f366e92$1_1@news.estpak.ee>

Hi!

Is it too late to rollback?

On which version are you? If on 9i, you might be able to use dbms_flashback package to see old state of your table, then copy the contents, drop original table and rename the copy back to original name (variations could be used if don't want to drop because of constraints & dependencies).

Otherwise you could do point in time recovery if you got a backup and logfiles from start of this backup until to point before you started your update (or before commiting this update works as well).

Tanel.

"MikeP" <nhojnacki_at_cox.net> wrote in message news:df791f74.0308100630.1596064b_at_posting.google.com...
> I intended to update certain rows in one table, instead I updated them
> all. What is the best way to recover the previous data in this one
> field, Or do I need to run a script that populates the field from
> another table. There is a table that does contain the correct data,
> but it is a one to many relationship ( the bad data has one value but
> the other has mulitple values for the same record ) and I'm not sure
> how this can be handled.
>
> regards
>
> -Mike
Received on Sun Aug 10 2003 - 11:10:57 CDT