自己编写了一个导入脚本，很简单，记录一下：
[App_server@14:14:48 ~/dmpscript]$cat impdp.sh
#!/usr/bin/bash
echo "Please enter your username"
read n
sleep 1
echo "Please enter the dumpfile name"
read m
sleep 1
:> /home/oracle/dmpscript/create_user.sql
echo "create user $n identified by $n default tablespace users temporary tablespace tmp quota unlimited on users;" >> /home/oracle/dmpscript/create_user.sql
echo "exit" >> /home/oracle/dmpscript/create_user.sql
:> /home/oracle/dmpscript/grant_privs.sql
echo "grant dba to $n ;" >> /home/oracle/dmpscript/grant_privs.sql
echo "exit" >> /home/oracle/dmpscript/grant_privs.sql
sqlplus sys/sys as sysdba @/home/oracle/dmpscript/create_user.sql
sleep 3
sqlplus sys/sys as sysdba @/home/oracle/dmpscript/grant_privs.sql
sleep 3
impdp $n/$n directory=dpdata dumpfile=$m schemas=test remap_schema=bdtom:$n
sleep 1
rm /db/app/oracle/oradata/dmp.tmp/$m
echo "dumpfile has been removed"
[App_server@14:14:52 ~/dmpscript]$
效果如下：
执行脚本后，提示输入用户名和dump文件名。完成后，就会自动将schema为test的dump文件导入到输入的schema里面。
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25915379/viewspace-720912/，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
