When dropping tables in Oracle 10g you find that they are not actually being dropped. This is a new feature where once a table is dropped it is put into a kind of recycle bin and appears like in the example below:
OBJECT_NAME
--------------------------------------------------------------------------------
BIN$Fh4GKL2HF6HgRAADug5S0A==$0
BIN$Fh4HVxp+GAvgRAADug5S0A==$0
PURGE TABLE "BIN$Fh4GKL2HF6HgRAADug5S0A==$0"; |
Related articles