Hi all,<br><br>
PURGE INDEX command purges the specified index from the recyclebin.<br>
My question is: I noticed that the dropped index doesn't appear in the recyclebin, so from where it could be purged?<br><br>
SQL> CREATE INDEX Z_IND ON Z (Z);
Index created.
SQL> DROP INDEX Z_IND ;
Index dropped.
SQL> SELECT OBJECT_NAME , ORIGINAL_NAME FROM USER_RECYCLEBIN ;
OBJECT_NAME ORIGINAL_NAME
------------------------------ ---------------
BIN$TNgWa0sgR8qFY7JXGVT3yQ==$0 T <<-- the dropped index doesn't appear here
SQL>CREATE INDEX Z_IND ON Z (Z);
Index created.
SQL> PURGE INDEX Z_IND ;
PURGE INDEX Z_IND
*
ERROR at line 1:
ORA-38307: object not in RECYCLE BIN
SQL> DROP INDEX Z_IND PURGE ;
DROP INDEX Z_IND PURGE
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
SQL> DROP INDEX Z_IND;
Index dropped.