rhel5_shell_删除重建用户user_导入dmp_脚本

[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]$
 
 
 
请使用浏览器的分享功能分享到微信等