Q: How to quickly delete all the tables of a user?
A:
Enter the following command: SELECT 'DROP TABLE' || Table_Name || ';' from DBA_TABLES Where Owner = 'The username of the table is deleted'; put the execution result of the query into the text file and execute it with SQL Plus. Yes.
