Dear Mr.Rajan,
Thanks for your mail.
Is there any way to recover through Logminer.
Regards,
Balu
----- Original Message -----
From: rajan <[Email Address Removed] LazyDBA.com Discussion <[Email Address Removed] Wednesday, March 31, 2004 1:56 PM
Subject: RE: Revoer Table

> Hi Balu ,
>
> It is not possible to recover the table as the database is no-archive log
> mode.If the database had been in archivelog mode there are lot many ways
to
> recover the data . But sorry in this case I don't think any method will
work
> out.if it is Oracle 9i there may be possiblity of recovering deleted rows
> thru dbms_flashback .But as your table is dropped ,I doubt whether the
flash
> back query would work in this case ..not tried yet. Also the flashback
query
> depends on your undo retention period .
>
> Regards
> Rajendra
> Tata Motors
> -----Original Message-----
> >From: Computer Centre - NIIPL [mailto:[Email Address Removed] Sent: Wednesday, March 31, 2004 12:53 PM
> 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
>
> --------
> 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 is scaned by eScan Anti Virus Software




Oracle LazyDBA home page