Recycle bin can be turned on/ off and on as follows:

alter system set "_recyclebin"=TRUE
alter system set "_recyclebin"=FALSE

See output below;



SQL> alter system set "_recyclebin"=TRUE;
System altered.

SQL> create table XYZ2 (ID number);
Table created.

SQL> drop table XYZ2;
Table dropped.


SQL> show recyclebin;
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
XYZ2 BIN$1OkO8Lh6CyzgNAADugRuEQ==$0 TABLE 2004-03-05:13:21:18

SQL> purge recyclebin;
Recyclebin purged.

SQL> alter system set "_recyclebin"=FALSE;
System altered.

SQL> create table XY (ID number);
Table created.

SQL> drop table XY;
Table dropped.

SQL> show recyclebin;