How to Recycle Bin

see Flashback too

select * from dba_recyclebin;

--Delete a table to recycle bin:
drop table prova;

--Restore table from recycle bin
FLASHBACK TABLE prova TO BEFORE DROP RENAME TO prova;

--Drop a table from recycle bin
PURGE TABLE BIN$jsleilx392mk2=293$0;
or
PURGE TABLE PROVA;--Purge a tablespace...
PURGE TABLESPACE users;
--...only objects belonging to a user
PURGE TABLESPACE users USER aldo;
--Purge the entire Recycle Bin for current user
PURGE RECYCLEBIN;
--purge all the objects in any tablespace
PURGE DBA_RECYCLEBIN

--Recycle bin can be turned on/ off and on as follows: 
alter system set "_recyclebin"=TRUE;
alter system set "_recyclebin"=FALSE;

show recyclebin

Get original names for purged triggers and keys...
    
SELECT OBJECT_NAME, ORIGINAL_NAME, TYPE
FROM USER_RECYCLEBIN
WHERE BASE_OBJECT = (SELECT BASE_OBJECT FROM USER_RECYCLEBIN
WHERE ORIGINAL_NAME = 'RECYCLETEST')
AND ORIGINAL_NAME != 'RECYCLETEST';