[size=11pt]SQL> drop table inv;[size=11pt]SQL> show recyclebin;[size=11pt]ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME[size=11pt]—————- —————————— ———— ——————-[size=11pt]INV BIN$0zIqhEFlcprgQ4TQTwq2uA==$0 TABLE 2013-01-11:12:16:49
[size=11pt]SQL> select object_name, original_name, type[size=11pt]from recyclebin;[size=11pt]Here is the output:[size=11pt]OBJECT_NAME ORIGINAL_NAM TYPE[size=11pt]———————————– ———— ————————-[size=11pt]BIN$0zIqhEFjcprgQ4TQTwq2uA==$0 INV_PK INDEX[size=11pt]BIN$0zIqhEFkcprgQ4TQTwq2uA==$0 INV_TRIG TRIGGER[size=11pt]BIN$0zIqhEFlcprgQ4TQTwq2uA==$0 INV TABLE
[size=11pt]SQL> flashback table inv to before drop;[size=11pt]SQL> select index_name from user_indexes where table_name=’INV’;[size=11pt]INDEX_NAME[size=11pt]————————————————-[size=11pt]BIN$0zIqhEFjcprgQ4TQTwq2uA==$0
[size=11pt]In this scenario, you have to rename the index:[size=11pt]SQL> alter index “BIN$0zIqhEFjcprgQ4TQTwq2uA==$0” rename to inv_pk;
[size=11pt]SQL> flashback table inv to before drop rename to inv_bef;