On Jul 9, 9:08 am, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> 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
Not correct.
Received on Wed Jul 11 2007 - 17:23:08 CDT
