Oracle deletes all objects under a user and performs with caution

Oracle deletes all objects under a user and performs with caution

In PL/SQL, click "New", "Command Window", Paste and execute directly

--Delete an object under a user
Set heading off;
Set feedback off;
Spool D:/dropobj.sql;
Prompt--drop Constraint
Select ' ALTER TABLE ' | | table_name| | ' drop constraint ' | | constraint_name| | '; ' from user_constraints where constraint_type= ' R ';
Prompt--drop Tables
Select ' Drop table ' | | table_name | | '; ' from User_tables;

Prompt--drop View
Select ' Drop View ' | | view_name| | '; ' from User_views;

Prompt--drop sequence
Select ' Drop sequence ' | | sequence_name| | '; ' from user_sequences;

Prompt--drop function
Select ' Drop function ' | | object_name| | '; ' from user_objects where object_type= ' FUNCTION ';

Prompt--drop procedure
Select ' drop procedure ' | | object_name| | '; ' from user_objects where object_type= ' PROCEDURE ';

Prompt--drop Package
Prompt--drop Package body
Select ' Drop Package ' | | object_name| | '; ' from the user_objects where object_type= ' package ';

Prompt--drop Database link
Select ' Drop database link ' | | object_name| | '; ' from user_objects where object_type= ' DATABASE LINK ';

Spool off;
Set heading on;
Set feedback on;

@@d:/dropobj.sql;
Host del D:/dropobj.sql;

Oracle deletes all objects under a user and performs with caution