yeah I did it too, when the programmer did a "update table set id = <some number>; where.... and then closed his session. In production. Took 3 hours (this was version 7, way before flashback query), to build the db on another server and update via a dblink. --- Daniel Fink <Daniel.Fink@xxxxxxx> wrote: > You can do object-level recovery from a backup. The advantage > with this is that you can get the object as of a point in time, > e.g. immediately before the table was dropped. The downside is > that you need someplace to create and recover the database. It > can be done (remember that Friday, Tim?) and the beers > afterwards taste all the more cool and refreshing. > > Daniel > > "Smith, Ron L." wrote: > > > > We do full exports on all databases at least once a day for table > level > > recovery if needed. We also do daily hot backups for point in time > > recovery. I feel there is a need for both. > > > > Ron Smith > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- __________________________________ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------