【Oracle】Clean all objects belong to particular the user but not using drop user xxx cascade

 

 

# -- WX:DBAJOE399 --

DEST_SCHEMA=Expected_user_name

sqlplus / as sysdba << !EOF

set serveroutput on
set echo off
set feedback off
WHENEVER SQLERROR EXIT 1
WHENEVER OSEEROR EXIT 1
alter session set current_schema=${DEST_SCHEMA};




purge dba_recyclebin;
  EXIT
!EOF