aspose file tools*
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
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: 261

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 , Oracle Java Web Component Developer
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3610
    
  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: 261

Thank you Martin ...
 
jQuery in Action, 2nd edition
 
subject: Recovering a dropped table ORA-38305: object not in RECYCLE BIN