posted 10 years ago
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".
Tea Addict, Oracle Java Programmer , Oracle SQL Expert , Oracle Java Web Component Developer, Oracle Web Service Developer