Useful SQL

The following SQL commands help you manage information in the Oracle database.

BIN$ objects

If the SA Installer discovers the existence of BIN$ objects in the database, enter the following SQL commands:

SQL>show parameter recyclebin;

SQL>SELECT owner,original_name,operation,type FROM dba_recyclebin;
connect <owner>/password 
SQL>purge recyclebin; 
or 
SQL>purge table BIN$xxx;

By default, recyclebin is set to OFF.