in our case, we weren't running rman... so we created a copy of the database, recovered to just before the problem (fortunately we had triggers which timestamp changes) and then used a database link from the copy to the original and updated the rows back to what they originally were. It was a website, we couldn't afford to be down for the time the recovery would take --- ryan.gaffuri@xxxxxxx wrote: > by object level recovery, do you mean that you create a copy of the > database, recovery it, then export the item or is there a way to use > rman to just grab the one object? > > > > From: Rachel Carmichael <wisernet100@xxxxxxxxx> > > Date: 2004/05/03 Mon PM 11:05:59 EDT > > To: oracle-l@xxxxxxxxxxxxx > > Subject: Re: Oracle recovery > > > ---------------------------------------------------------------- > 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 -----------------------------------------------------------------