批量删除oracle用户表空间代码,Shell代码库,德仔网

代码语言

代码分类

【Shell】批量删除oracle用户表空间

作者:wangjianghuan / 发布于2011/8/31/ 1019

<div>!/bin/bash
# get cuttent path
selfpath=$(cd "$(dirname "$0")"; pwd) 
echo "current path" $selfpath
echo "Warning : File path is best not to have Chinese !"
echo "Is going on ? [y/n]"
read YES_OR_NO 
if [ "$YES_OR_NO" != "y" ]; then 
echo "Good bye!"
exit 1
else
echo drop user
sqlplus <a href="mailto:system/system@bip_oracle_design">system/system@bip_oracle_design</a> @$selfpath/drop_user_design.sql
echo drop tablespace
sqlplus <a href="mailto:system/system@bip_oracle_design">system/system@bip_oracle_design</a> @$selfpath/drop_tablespace_design.sql
echo delete dbf file
rm -r /export/home1/oracle/enzymedata/enzyme/design/bip_ts_design.dbf
rm -r /export/home1/oracle/enzymedata/enzyme/design/esap_default_design.dbf
rm -r /export/home1/oracle/enzymedata/enzyme/design/report_ts_design.dbf
rm -r /export/home1/oracle/enzymedata/enzyme/design/workflow_ts_design.dbf
rm -r /export/home1/oracle/enzymedata/enzyme/design/portal_ts_design.dbf
echo delete success
echo "The End"
fi
exit 0</div>

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　删除oracle用户表　

同语言下

可能有用的

wangjianghuan贡献的其它代码(2)