Delete all objects under the current oracle user

Delete all objects under the current oracle user SQL code --. SQL script-the only note is the following D: \ dropobj. SQL is the operation. SQL; -- used to delete all objects of the current user -- use for drop all objects in current user; set heading off; set feedback off; spool D: \ dropobj. SQL; prompt -- delete constraints select 'alter table' | table_name | 'drop constraint' | constraint_name | ';' from user_constraints where constraint_type = 'R '; prompt -- delete a table select 'drop table' | table_name | ';' from user_tables; p Rompt -- delete view select 'drop view' | view_name | ';' from user_views; prompt -- delete sequence select 'drop sequence '| sequence_name |'; 'from user_sequences; prompt -- delete the function select 'drop function' | object_name | ';' from user_objects where object_type = 'function '; prompt -- delete stored procedure select 'drop processed' | object_name | ';' from user_objects where object_type = 'processed'; prompt -- delete package prompt -- delete Package content select 'drop Package '| object_name |'; 'from user_objects where object_type = 'package'; prompt -- delete database link select 'drop database link' | object_name | '; 'From user_objects where object_type = 'database link'; prompt -- delete the hidden object select 'drop synonym' | object_name | ';' from user_objects where object_type = 'synonym '; prompt -- delete materialized view select 'drop materialized view' | object_name | ';' from user_objects where object_t Ype = 'materialized view'; spool off; set heading on; set feedback on; @ D: \ dropobj. SQL; host del D: \ dropobj. SQL; -- done for drop objects in current user; -- use this entire segment in SQL * PLUS. SQL import or copy and paste directly, and press F5 to execute.