Remove Flashback drop Feature

To disable the Flashback Drop Feature set the init parameter RECYCLEBIN to OFF.

To remove all objects from the recycle bin that are part of a Tablespace,

SQL> Purge Tablespace users;

To remove all objects of a single user, scott (along with any dependent objects that live in other Tablespaces) from the Tablespace users,

SQL> Purge Tablespace users USER scott;

To query the table in recyclebin

SQL> Select * from owner.”recyclebin_name”;

SQL> Select * from ins."BIN$YkyfmFKl8MLgQwppGAzwwg==$0";

Note 1: The recycle bin name must be enclosed within double quotes.

Note 2: You can only query the objects in Recycle bin, no DML is allowed.

Oracle renames all objects in the recycle bin, including any dependent objects such as indexes, constraints, triggers etc. When you recover a table, oracle will recover the dependent objects as well, but they’ll retain these cryptic system generated names, so you will need to rename them appropriately.

Thanks