This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I am not able to recover the dropped table.
It seems that it directly drops the table altogether from the disk rather than saving it in the recycle bin.
I have recycle bin set to on.Still it doesn`t save my dropped tables to recyclebin.How can i recover my dropped tables.
When i try to flashback table it results in error saying object does not exists i the recyclebin.
here is what i am trying to do in my sql * PLUS release:10.2.0.1.0
create table example(id number);
drop table example;
flashback table example to before drop;
errorbject does not exists in recyclebin
I have tried from other than system account but get the same result.