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

[Mahtab Alam]

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".

[Martin Vashko]

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]

Thank you Martin ...