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

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