SQL> create user abce identified by abce;

User created.

SQL> grant resource,connect to abce;

Grant succeeded.

SQL> conn abce/abce

Connected.

SQL> purge dba_recyclebin;

purge dba_recyclebin

*

ERROR at line :

ORA-: insufficient privileges

SQL> conn /as sysdba

Connected.

SQL> grant purge dba_recyclebin to abce;

Grant succeeded.

SQL> conn abce/abce

Connected.

SQL> purge dba_recyclebin;

DBA Recyclebin purged.

SQL>