文章标题

–导入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;