In Oracle 10g, we have the concept of RECYCLEBIN, which houses all the dropped objects under a different name (like...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.