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] 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] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page