Thursday, July 16, 2009

DBA_RECYCLEBIN

alter system set recyclebin='ON';

show parameter recycle

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
recyclebin string ON

drop table test;
select owner, object_name, original_name from dba_recyclebin;
flashback table test to before drop;


purge dba_recyclebin;