Search notes:

Oracle SQL: PURGE

purge table      T;
purge index      I;
purge tablespace TS;
Purge the recycle bin of the user executing the command:
purge recyclebin;
With SYSDBA or PURGE DBA_RECYCLEBIN privileges, the entire recyclebin can be purged:
purge dba_recyclebin;

See also

The init parameter recyclebin.

Index