HomeХобби и стильRelated VideosMore From: jbleistein11

Oracle DBA Justin - How to drop all objects in the recycling bin, regardless of owner

2 ratings | 1533 views
How to drop all objects in the recycling bin, regardless of owner
Html code for embedding videos on your blog
Text Comments (2)
jbleistein11 (7 years ago)
@yourcatjack ALL_ALL_TABLES will return system generated tables as well as all tables sys has privilege to. --Justin
jbleistein11 (7 years ago)
@yourcatjack - There could be database sizing reports which need to be accurate as far as budgeting goes, or more disk space justification goes. Also, maybe you want to delete a dropped table from the recyclebin because it is confidential, and it being in the recycle bin is not good enough? --Justin

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.