Drop user cascade and start sql server browser
select 'drop user "' || username || '" cascade; ' from dba_users WHERE username like 'name%';
sql server browser must start, if you want use remote sql connection
the bat want to delete temporary users in oracle, we can arrange time in windows scheduled Tasks
clearOraUser.bat
content:
C:\oraclexe\app\oracle\product\10.2.0\server\BIN\sqlplus user/psd@xe as sysdba @C:\generate.sql
echo quit >> c:\cleartOraUser.sql
C:\oraclexe\app\oracle\product\10.2.0\server\BIN\sqlplus user/psd@xe as sysdba @c:\cleartOraUser.sql
exit;
generate.sql
content:
set heading off
set feedback off
SET ECHO OFF
spool c:\cleartOraUser.sql;
select 'drop user "' || username || '" cascade; ' from dba_users WHERE username like 'TESTNAME%';
spool off
quit
we first call clearOraUser.bat, then generate sql c:\cleartOraUser.sql, then we execute this generate sql.