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,244 of 2,288    |
|    Snonck to Steven Patterson    |
|    Re: Recover deleted rows from a table fr    |
|    26 Oct 06 22:22:40    |
      From: snonck@snog.com              Thanks for your reply.              I accidentally posted this question here instead of into       comp.databases.oracle.server.              I have now moved the question into the above newsgroup as it is a little       more livelier. I'm still trying to find out what the answer is as there       seems to be a bit of discussion about it.                            Steven Patterson wrote:       > 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.              --- 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