How to recover a dropped tabled in oracle 9i [message #213566] |
Thu, 11 January 2007 05:12 |
ravivkumar
Messages: 34 Registered: April 2005 Location: chennai
|
Member |
|
|
HI Friends
Kindly give the solution,
Suddently a table is dropped from the production database,
we have the last day backup and also the database is in archive mode.how to recover the dropped tabled.
Regards
Ravikumar.V
|
|
|
|
|
|
|
|
Re: How to recover a dropped tabled in oracle 9i [message #214407 is a reply to message #213605] |
Tue, 16 January 2007 05:41 |
ninja
Messages: 6 Registered: August 2006 Location: INDIA
|
Junior Member |
|
|
hi there,
i went through ur quey and ppl said u required incomplete reecovery
well its still possib to recover completely
1.take backup of ur current db
2. apply previous day backup
3. do point in time recovery to get table back
4. export table
5. shutdown and apply latest backup (done 2day)
6. import table back
regards
hardik
|
|
|