SQL> select object_name,original_name,createtime,Space from user_recyclebin Order By Space Desc;

OBJECT_NAME                    ORIGINAL_NAME                    CREATETIME               SPACE

------------------------------ -------------------------------- ------------------- ----------

BIN$Igh2vIqNsMrgU8CoATewyg==$0 SZ_PTS_DEC_HEAD                  2014-06-03:18:40:56     588288

BIN$Igh2vIqVsMrgU8CoATewyg==$0 SZ_PTS_DEC_HEAD_STEP             2014-06-03:14:37:10     524288

BIN$2PbS9QfUQIjgQ8CoATdAiA==$0 WTCM_HZ_HISTORY_CUSTOMS_LIB      2012-03-04:14:21:38      65536

BIN$1N4DD1N80IzgQ8CoATfQjA==$0 SZ_ENTRY_PRICE_2012              2013-02-04:10:50:20      59520

BIN$1N4DD1N40IzgQ8CoATfQjA==$0 SZ_ENTRY_PRICE_2012              2013-02-04:10:40:17      59520

BIN$1N4DD1N00IzgQ8CoATfQjA==$0 SZ_ENTRY_PRICE_2012              2013-02-04:10:30:33      59520

BIN$zv10vkidQBbgQ8CoATdAFg==$0 SZ_PTS_DEC_HEAD_TEST             2012-11-21:10:35:13      59520

BIN$Igh2vIqQsMrgU8CoATewyg==$0 IDX_GOODA_PASS_TIME              2014-06-03:14:47:40      58368

BIN$2PbS9QfSQIjgQ8CoATdAiA==$0 IDX_WTCM_CODE_NAME_MOD           2012-03-04:14:21:51      52224

BIN$Igh2vIqPsMrgU8CoATewyg==$0 IDX_I_E_FLAG                     2014-06-03:14:45:04      38912

BIN$Igh2vIqRsMrgU8CoATewyg==$0 IDX_STEP_COMPANY_CODE            2014-06-04:13:55:51      37888

BIN$Igh2vIqKsMrgU8CoATewyg==$0 IDX_SZ_PTS_DEC_HEAD_HISTORY43    2014-06-20:17:32:57      28672

BIN$Igh2vIqUsMrgU8CoATewyg==$0 IDX_STEP_ENTRY_ID                2014-08-25:11:17:55      28672

BIN$Igh2vIqIsMrgU8CoATewyg==$0 IDX_SZ_PTS_DEC_HEAD_HISTORY33    2014-06-20:17:27:38      26624

BIN$2PbS9QfTQIjgQ8CoATdAiA==$0 IDX_WTCM_ENTITYID                2013-03-07:18:25:58      25600

BIN$8uWe64JvANjgQ8CoATcA2A==$0 SZ_PTS_DEC_HEAD_STEP_TEMP        2014-02-21:14:11:32      21504

BIN$Igh2vIqLsMrgU8CoATewyg==$0 IDX_SZ_PTS_DEC_HEAD_OID          2014-06-25:11:16:34      19456

BIN$Igh2vIqTsMrgU8CoATewyg==$0 IDX_I_E_DATE2                    2014-07-18:15:18:32      18432

BIN$Igh2vIqSsMrgU8CoATewyg==$0 IDX_STEP_DECLARE_DATE            2014-06-04:13:58:07      18432

BIN$2FXfVidAIIDgQ8CoATcggA==$0 SZ_SEND_CONTROL_HISTORY          2012-03-04:14:18:45      10240

BIN$5vNFxThv8BLgQ8CoATfwEg==$0 SZ_COMPANY_REL_BAK1              2013-02-01:16:36:01       9216

OBJECT_NAME                    ORIGINAL_NAME                    CREATETIME               SPACE

------------------------------ -------------------------------- ------------------- ----------

BIN$JLcyBbGsoETgU8CoATegRA==$0 KHI_NEW_ORDER_ARCHIVE            2015-11-11:10:08:49       4992

633 rows selected

#执行

SQL> purge table "BIN$Igh2vIqNsMrgU8CoATewyg==$0";

SQL> purge table "BIN$Igh2vIqVsMrgU8CoATewyg==$0";

本文转自zylhsy 51CTO博客，原文链接：http://blog.51cto.com/yunlongzheng/1714888，如需转载请自行联系原作者