–导入dmp文件
imp bank1231/bank1231@ORCL file=”F:\xhns20150206.dmp full=”y”
1.先创建目录 impdir将导入文件放进去,
2.数据库中创建 directory对应impdir
3.执行导入
创建逻辑目录:create directory impdir as ‘E:\impdir’;
赋予权限:grant read,write on directory impdir to bank;
查询是否成功:select * from dba_directories;
执行导入:impdp bank1231/bank1231 DIRECTORY=impdir DUMPFILE=xhns20150206.dmp FULL=y;