Shulou(Shulou.com)06/01 Report--

Editor to share with you how oracle batch delete tables, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!

Some tables are sometimes deleted when managing oracle. Manual deletion is not only time-consuming but also laborious. You can use scripts to delete tables under a user in batches, import delete statements into a file in oracle, and then execute the file.

Set pagesize 0

Spool / tmp/drop.sql

Select 'drop table' | | table_name | | 'cascade' | |'; 'from all_tables where owner='USERNAME'

Spool off

Execute script

@ / tmp/drop.sql

The above is all the contents of the article "how to delete tables in batches by oracle". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.