| |
Posted: Feb 21, 2008 05:16:50 AM |
Total Post: 46
Joined: Sep, 2007
|
Hi all,
i had more 20 tables in my database, but i deleted 3 tables yesterday.how i will recover those 3 tables using RMAN.
|
|
|
 Mohammed Taj |
| Posted: Feb 21, 2008 07:28:56 AM |  |
|
Total Post: 746
Joined: Jul, 2007
|
first give us your database version?
if 10g then use flashback option and restore your table from recyclebin.hopefully you drop table without PURGE option.
search on net you will get exact syntax.
otherwise you have last full backup then perform incomplete recovery.
Regards
Taj
|
|
|
|
|
| |
| Posted: Feb 22, 2008 12:15:36 AM | |
|
Total Post: 46
Joined: Sep, 2007
|
Hi Taj
i m usiing oracle 9.0.2.1.0 version on Win NT platform.
plz tell the steps plz.......
Thanks in advance.
|
|
|
|
|
| pammi |
| Posted: Feb 29, 2008 05:28:43 AM | |
|
Total Post: 21
Joined: Feb, 2008
|
Please follow the link to see an example
http://www.itk.ilstu.edu/docs/Oracle/server.101/b10759/statements_9012.htm
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
