if ur using oralce9i then you can get back that table
using flashback query option.


--- Yanir Tahan <[Email Address Removed] wrote: > Hi.
>
> Which Oracle version is it ?
>
>
> Yanir.
>
> -----Original Message-----
> From: [Email Address Removed] [mailto:[Email Address Removed] Sent: Wednesday, March 31, 2004 9:23 AM
> To: LazyDBA.com Discussion
> Subject: Revoer Table
>
>
> Dear All,
>
> Our Database is running on Non-Archive Log Mode.
> Daily we are taking Exp
> Backup. One new table which was created this morning
> ( Contains more than
> 1000 Rows) Drooped by one of our Programmer. How to
> recover that table?
>
> Thanks & Regards,
> Balu.
> This mail is scaned by eScan Anti Virus Software
>
>
>
>
>
> --------
> Get today's cartoon: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here:
> http://tahiti.oracle.com
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
>
**********************************************************
> This Mail Was Scanned By MATRIX PineApp Mail-Secure
> System
> and was found clean.
>
> IMPORTANT: Do not open attachments from unrecognized
> senders !!!
>
***************************JRS****************************
>
> --------
> Get today's cartoon: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here:
> http://tahiti.oracle.com
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>

________________________________________________________________________
Yahoo! India Insurance Special: Be informed on the best policies, services, tools and more.
Go to: http://in.insurance.yahoo.com/licspecial/index.html
Oracle LazyDBA home page