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.

posted on 2012-06-29 11:17  子虚乌有  阅读(219)  评论(0)    收藏  举报