RE: In Oracle10g sqlplus, how do you find the tables that have been dropped?
When you drop a table normally the database does not immediately release the space associated with the table. Rather the database renames the table and places it in a recycle bin where it can later be recovered with the FLASHBACK TABLE statement if you find that you dropped the table in error.