Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

I am not able to recover dropped table

Mahtab Alam
Ranch Hand
Posts: 391
Java MySQL Database PHP
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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:

connect system/aaa;

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.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic