aspose file tools*
The moose likes Oracle/OAS and the fly likes I am not able to recover dropped table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "I am not able to recover dropped table" Watch "I am not able to recover dropped table" New topic
Author

I am not able to recover dropped table

Mahtab Alam
Ranch Hand

Joined: Mar 28, 2012
Posts: 172

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

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.


Mahtab Alam (OCJP )
Blogs : alamsql.blogspot.in , alammahtab.blogspot.in
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: I am not able to recover dropped table
 
Similar Threads
Unexpected tables in list
Restoring "$Recycle.bin" files
Increasing Disk Partition Size on Linux
Data recovery using stored procedure
Recycle bin in linux