源库：aix 10.0.2

目标库：win server 11.0.2.0

(1)创建表空间

1、create tablespace EAS_D_EAS522_GOLD_STANDARD logging datafile 'D:\app\Administrator\oradata\renhe\EAS_D_EAS522_GOLD_STANDARD.dbf' size 15g autoextend on extent management local;

 (2)创建临时表空间

create temporary tablespace EAS_D_RHGF_TEMP1  tempfile 'D:\app\Administrator\oradata\renhe\EAS_D_RHGF_TEMP1.dbf' size 5g autoextend on extent management local;

(3)创建用户(rhpdm,rhjtoa rhbs rhgf)

create user rhgf identified by xxx default temporary tablespace EAS_D_RHGF_TEMP1;

create user rhpdm identified by xx

create user rhjtoa identified by xx

create user rhbs  identified by xx

（4）创建目录

create directory RH_DUMP as 'D:\ProgSETUP\RHGF20170603' （路径是存放备份文件的路径）

（5）给用户授权

grant read,write on directory RH_DUMP to rhgf;

grant connect,resource,dba to rhgf

(6)还原备份

impdp rhgf/xx directory=RH_DUMP  dumpfile=RHGF_U_20170603.dmp   (table_exists_action=replace;这个参数在重复执行时候使用第一次恢复时不需要用)

注意事项

(1) ora-01653 EAS_D_EAS522_GOLD_STANDARD表空间无法扩展  解决方法如下 建多个数据文件

ALTER TABLESPACE EAS_D_EAS522_GOLD_STANDARD ADD DATAFILE  'D:\app\Administrator\oradata\renhe\EAS_D_EAS522_GOLD_STANDARD_2.dbf' SIZE 500m  AUTOEXTEND ON NEXT 500m MAXSIZE UNLIMITED;

(2):数据库字符集要一致 最好是用utf8