Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: exp and archive available.... recover table
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
Received on Mon Jul 09 2007 - 06:42:29 CDT
![]() |
![]() |