Oracle Backup & Recovery Techniques - Oracle 10g Database Administration Concepts and Implementation Made Simple - page 329

In order to purge the table completely from the recycle bin use
the PURGE command as shown below.

SQL> PURGE TABLE emp;

For purging the user recycle bin use the following statement.

SQL> PURGE recyclebin;

To purge the dba recycle bin use the following command.

SQL> PURGE dba_recyclebin;

The following statement purges all objects from tablespace users
in the recycle bin:

SQL> PURGE TABLESPACE users;

To get the information of what is inside the recycle bin use the
following statements.

SQL> SHOW RECYCLEBIN;

SQL> SELECT object_name as bin_nick, original_name
FROM RECYCLEBIN;

Flashback Table

FLASHBACK TABLE can be used to take the table to prior
point in time or prior state based on SCN. It is the fastest
technique for quick data recovery for table level mistakes or data
corruptions. Before running a Flashback Query, make sure that
the database is running under Automatic Undo Management and
you have set the UNDO_RETENTION initialization parameter.
Moreover, set the undo tablespace with RETENTION
GUARANTEE option, this will make sure nothing gets over
written in case undo tablespace gets full before

UNDO_RETENTION period.