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?
thanks