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,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