Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Mahtab Alam
Ranch Hand
Posts: 391
1
Java MySQL Database PHP
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 391
1
Java MySQL Database PHP
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you Martin ...
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic