home bbs files messages ]

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