Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How the PURGE INDEX command works

200754Mar 12 2007 — edited Mar 12 2007

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 9 2007
Added on Mar 12 2007
1 comment
2,951 views