Re: exp and archive available.... recover table

On Jul 9, 6:42 am, Steve Robin <ocma..._at_gmail.com> wrote:
> On Jul 9, 4:28 pm, sybrandb <sybra..._at_gmail.com> wrote:
>
>
>
>
>
> > On 9 jul, 13:22, Steve Robin <ocma..._at_gmail.com> wrote:
>
> > > Last night I took table backup with exp command.
> > > Now since morning so many people worked on database, in evening one
> > > table was dropped.... (user error).
> > > Now I have all archive after that export.... I know that table can be
> > > recoverd with all data by using log minor.
> > > But I don't know how.... can someone pls help me with this.
> > > Any doc or link will help a lot....
>
> > > thanks
>
> > Look up dbms_logmnr and dbms_logmnr_d in the Oracle supplied packages
> > manual for your version.
>
> > NB: Exp is NOT a *backup*
>
> > also dbms_logmnr doesn't support all operations.
>
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
>
> Thanks for help.
> if I am not mistaking.... exp is logical backup.... which can help to
> recover these kind of user errors as well as help us to find any block
> corruption also.
> Please inform.... because if it is wrong then I apologies for wrong
> comment for export.
> thanks- Hide quoted text -
>
> - Show quoted text -

An export is a logical copy of the object or objects exported at the time the object copy began. It is not a backup, even in the loosest sense of the word.

David Fitzjarrell Received on Mon Jul 09 2007 - 08:08:45 CDT