rhel5_shell_刪除重建使用者user_匯入dmp_指令碼

wisdomone1發表於2010-07-21
指令碼
[oracle@localhost 32db]$ more drop_user_pd.sh
#!/bin/bash
source /webapps/oracle/.bash_profile
sqlplus '/as sysdba'>>/webapps/oracle/32db/shell_drop_pd.log<drop user pd cascade;
create user pd identified by system default tablespace tongyihua account unlock;
grant resource,connect,alter any procedure,create view,create procedure to pd;
exit;
EOF
imp userid=system/system fromuser=pd touser=pd file=/webapps/oracle/32db/20100721_export_pd.dmp log=/webapps/oracle/32db/20100721_imp_pd.log
[oracle@localhost 32db]$
 
 
 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/9240380/viewspace-668648/，如需轉載，請註明出處，否則將追究法律責任。

相關文章