In Oracle 10g, we have the concept of RECYCLEBIN, which houses all the dropped objects under a different name (like...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.