Re: URGENT: Please help with an recovery option...

Okey, the first thing that you need to know is.. have you commit the changes? If no, just issue a rollback and it will cancel the whole transaction (it you have run several DML without commiting or having any save point.. all the transactions will be gone!)

If you have already commit the change, then there is still a chance for you to recover your database if you are running in the archive log mode. If you are running in the archive log mode, and that table is really important to you. Then shut down the database. Restore all the datafile from backup (not the control file), then mount the database. Issue the recover database until '<time>' <-use a time just before you update your table. Then open your database as a resetlog option.

Good Luck

Winnie

nnoor wrote in message <6s1lj4$bil_at_chronicle.concentric.net>...
>
>I am still kicking myself... I ran an update query on a table
>which also modified some data which it wasn't supposed to (failed
>to include an option in the where clause). Is there any way to
>get teh data to the way it was? Any type of roll back? Anything?
>
>Thanks and Regards,
>Nasir (nnoor_at_cris.com)
Received on Wed Aug 26 1998 - 00:00:00 CDT