Methods for Oracle to delete all tables under the current user

1. If you have permission to delete a user, you can:

Drop user user_name cascade;

Add the cascade can delete the user data.

Delete and then create the user.
--Create an administrator user
Create user username identified by password default tablespace space_data (tablespace name) temporary tablespace space_temp (temporal tablespace name);
--Authorization
Grant CONNECT,DBA to user name;
--Revision limits
ALTER user "username" QUOTA UNLIMITED on space_data (table space name);

--View all user objects
Select Uo.object_name,uo.object_type from user_objects uo where uo.object_type<> ' lobs ' ORDER by uo.object_type Desc

2, if you do not delete the user's rights, you can do:

Select ' Drop table ' | | table_name| | '; '
From Cat
Where table_type= ' table '

Will output a batch of SQL statements to delete the table, these SQL statements can be executed. (Requires permission to drop table)

Methods for Oracle to delete all tables under the current user