Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.oracle    |    Overblown overpriced overengineered SHIT    |    2,288 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 2,243 of 2,288    |
|    Steven Patterson to Snonck    |
|    Re: Recover deleted rows from a table fr    |
|    26 Oct 06 07:16:47    |
      From: S.R.Patterson@soton.ac.uk              On Oct 26, 2006 at 8:53am Snonck wrote:       S> Is is possible to recover deleted rows from a table from archive logs?              Typically not, as the archivelogs need only record (and, as I understand       it, DO only record) the rowid of the deleted row - when rolling forward       (as the archivelogs are intended to be used) this is all the information       you need about the transaction.              Your options for recovery (you probably already know this) would be Oracle       Flashback, if you're in time, or a point-in-time recovery of the database       to a separate instance, and export of the table.              S.       --       Steven Patterson, MSci (Hons), Oracle Certified Professional              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca