SQL> CREATE TABLE CORUSER

  2  (                               

  3  UID_                   NUMBER(10)

  4  );

Table created.

SQL> create index coruse_idx on coruser (uid_);

Index created.

SQL> select OBJECT_NAME from user_objects;

OBJECT_NAME

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

CORUSE_IDX

CORUSER

SQL> drop table coruser;

Table dropped.

SQL> show recyclebin;

ORIGINAL NAME    RECYCLEBIN NAME                OBJECT TYPE  DROP TIME

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

CORUSER          BIN$d4kkaiiPisrgQOAKxLcy0w==$0 TABLE        2009-11-04:09:21:57

SQL> select OBJECT_NAME ,ORIGINAL_NAME from recyclebin;

OBJECT_NAME                    ORIGINAL_NAME

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

BIN$d4kkaiiPisrgQOAKxLcy0w==$0      CORUSER

BIN$d4kkaiiOisrgQOAKxLcy0w==$0      CORUSE_IDX

SQL> select count(*) from "BIN$d4kkaiiPisrgQOAKxLcy0w==$0";

  COUNT(*)

----------

         0

SQL> desc "BIN$d4kkaiiPisrgQOAKxLcy0w==$0"

 Name                                                  Null?    Type

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

 UID_                                                           NUMBER(10)

SQL> flashback table coruser to before drop;

Flashback complete.

SQL> select OBJECT_NAME ,ORIGINAL_NAME from recyclebin;

no rows selected

SQL> select OBJECT_NAME from user_objects;

OBJECT_NAME

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

CORUSER

BIN$d4kkaiiOisrgQOAKxLcy0w==$0

SQL> alter index "BIN$d4kkaiiOisrgQOAKxLcy0w==$0" rename to CORUSE_IDX;

Index altered.

SQL> select OBJECT_NAME from user_objects;

OBJECT_NAME

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

CORUSER

CORUSE_IDX