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

On Mon, 09 Jul 2007 04:22:33 -0700, Steve Robin <ocmaman_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....

If this is 10g, try looking for table in the recycle bin.

-a

.......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Mon Jul 09 2007 - 22:20:50 CDT