I dropped a table...then i attempted to bring it back with flashback to before drop...but i get the following...
SQL> flashback table tony to before drop;
flashback table tony to before drop
ERROR at line 1:
ORA-38305: object not in RECYCLE BIN
I thought Oracle10g (my version) stores a copy in the recyclebin by default? Do you do anything to enable this action?
Life is what is happening today while you were planning tomorrow.
See, there are some exceptions of the recycle bin policy.
Not sure, but I belive objects of the SYSTEM tablespace are not covered by the recycle bin. Also Dictionary managed tablespaces are not covered. So check if u do not create objects in the system tablespace, and also that the tablespace u use is locally managed. Or better create a new locally managed tablespace, create a new table there, drop it and then see if it operates