This can happen when a user with
privileges on a table that exists in multiple environments intends to drop a table in a development
environment but is pointing to the production database when the command is executed.
SQL> drop table AUTHOR cascade constraints;
Table dropped.
How can the table be recovered? As of Oracle Database 10g, a dropped table does not fully
disappear. Its blocks are still maintained in its tablespace, and it still counts against your space
?–
?–
?–
?–
I
Chapter 14: Miscellaneous High Availability Features 497
quota. You can see the dropped objects by querying the RECYCLEBIN data dictionary view. Note
that the format for the OBJECT_NAME column may differ between versions:
SQL> select object_name, original_name, operation, type, user,
2 can_undrop, space from recyclebin;
OBJECT_NAME ORIGINAL_NAME OPERATION
------------------------------ -------------------- ---------
TYPE USER CAN_UNDROP SPACE
------------------------- --------------- ---------- ----------
BIN$OyXS+NT+J47gQKjAXwJcSA==$0 AUTH_NAME_IDX DROP
INDEX HR NO 384
BIN$OyXS+NT/J47gQKjAXwJcSA==$0 AUTHORS DROP
TABLE HR YES 1152
SQL>
RECYCLEBIN is a public synonym for the USER_RECYCLEBIN data dictionary view, showing
the recycle bin entries for the current user. DBAs can see all dropped objects via the DBA_
RECYCLEBIN data dictionary view.
As shown in the preceding listing, a user has dropped the AUTHOR table and its associated
primary key index.
Pages:
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752