因为客户那是oracle11G ,而公司是10G,导入后有问题,用编辑器打开dmp文件,把头信息改成11G的信息,也导入不成功,导入11G的数据库时,因为编码不致,有些空表导入不进去
解决方法:
导入:
create directory dmpbx as 'D:\dbbak';//创建一个目录,并把dmp文件放在这个目录下
grant read,write on directory dmpbx to public;
impdp jxxy/jxxy@orcl directory=dmpbx dumpfile=aa.dmp logfile=aa_20131101.log REMAP_SCHEMA=e7cc:jxxy
导出:
create directory dmpbx as '/dbbak';
grant read,write on directory dmpbx to public;
expdp jxxy/jxxy@orcl dumpfile=aa.dmp directory=dmpbx;