Re: Backup

Priya Pattada wrote:

> Hello,
>
> I have a question, if a user on the system accidently updated or deleted
> the wrong rows of a table and signed off the system, what type of backup
> would the DBA need for recovery? The rows that were updated wrongly need
> to be got back without losing any other rows that have been updated and
> commited by other users
> during the same period of time.
>
> Thank you in advance for your help.
> Priya

As far as I know, this is impossible using recovery. Recovery to a point in time involves recovering the whole database and cannot be done for just a table.

--
Hope this helps !
Regards,
Srini
(to reply via email, please change "nospam" to "chavali" in my email address
-  :-)  )