In Oracle 10g, we have the concept of RECYCLEBIN, which houses all the dropped objects under a different name (like BIN$%).
At the same time, the DBA_TABLES has a column called 'DROPPED' which indicates whether a table has been dropped, and if it is present in RECYCLEBIN or not.
Now, if I drop a table, then the corresponding row from DBA_TABLES is deleted. What, then, is the significance of the 'DROPPED' column? Practically, it would only have a value of 'NO' (or null maybe), and never a 'YES.'
Dig Deeper on Oracle DBA jobs, training and certification
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.