wood burning stoves 2.0*
The moose likes Oracle/OAS and the fly likes Recovering a dropped table  ORA-38305: object not in RECYCLE BIN Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Recovering a dropped table  ORA-38305: object not in RECYCLE BIN" Watch "Recovering a dropped table  ORA-38305: object not in RECYCLE BIN" New topic
Author

Recovering a dropped table ORA-38305: object not in RECYCLE BIN

Mahtab Alam
Ranch Hand

Joined: Mar 28, 2012
Posts: 222

I used the code from Steve`s book to recover a dropped table

CREATE TABLE HOUDINI (VOILA VARCHAR2(30));
INSERT INTO HOUDINI (VOILA) VALUES ('Now you see it.');
COMMIT;
DROP TABLE HOUDINI;
1 FLASHBACK TABLE HOUDINI TO BEFORE DROP;
2 SELECT * FROM HOUDINI;

But it gives following error "Error at line 1 ORA-38305: object not in RECYCLE BIN".


Oracle Java Programmer , Oracle SQL Expert
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3606
    
  60

Your script works as expected in my database.

A quick search on the internet revealed that tables in the SYSTEM tablespace don't go into recyclebin. Aren't you by change trying this with a user that has the SYSTEM tablespace as a default?

https://community.oracle.com/message/1619135?#1617135
https://community.oracle.com/thread/593728
Mahtab Alam
Ranch Hand

Joined: Mar 28, 2012
Posts: 222

Thank you Martin ...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Recovering a dropped table ORA-38305: object not in RECYCLE BIN
 
Similar Threads
JDBC ORACLE - java.sql.SQLException: ORA-3160
I am not able to recover dropped table
Recovering shift-deleted files in Windows XP.
Not able to drop user Oracle10.2.0.3 Ent Ed.
Restoring "$Recycle.bin" files