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 Admin user user name identified by password default tablespace space_data (tablespace name) temporary tablespace space_temp (temporary tablespace name); --authorizing grant CONNECT,DBA to username; --Modify the quota alter user "username" QUOTA UNLIMITED on Space_data (tablespace name);
--View all user objects Select Uo.object_name,uo.object_type from User_objects uo where uo.object_type<> ' LOB ' 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