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

 

 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

# -- 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